MS Access AutoNumber reset.

Access AutoNumber reset.

1. Open the table that contains the AutoNumber field you want to reset.
2. Make a backup of your table to ensure you do not lose any data.
3. Create a new table with the same structure as the table you want to reset the AutoNumber field for.
4. Copy all the records from the original table to the new table, excluding the AutoNumber field.
5. Delete the original table.
6. Rename the new table to the original table's name.
7. Open the new table and add a new record. The AutoNumber field should start with 1.

Alternatively, you can use the following SQL command to reset the AutoNumber field for a specific table:

ALTER TABLE table_name ALTER COLUMN column_name COUNTER(1,1);

Replace table_name with the name of your table and column_name with the name of the AutoNumber field you want to reset.

Note: resetting an AutoNumber field will permanently delete all existing records in the table and assign new numbers to new records added after the reset. Make sure you have a backup of your data before attempting to reset the AutoNumber field.