The Change field "AutoNumber" type appears in Access and cannot be changed back! (Resolved)

The Change field "AutoNumber" type appears in Access and cannot be changed back! (Resolved)

Once you have changed the self-increment field in access to a numeric value and then changed back to self-increment, tip: After you enter data in the table, you cannot change any of the field data types to "AutoNumber" errors, the workaround:

1, right-click the table, design, open the field design status.

2. Remove the self-increment field you want to change.

3. Add a field on the last side (with the same name as the deleted field) and set it to auto-number.