How to reset the autoincrement field in MS Access Table
Many times we use autoicrement field in Ms Access table and we have noticed that the value of autoincrement field keeps on increasing ever if we delete all the rows of the table and add new row.
In order to reset the autoincrement field value back to 1, do the following:
1. Delete all the rows from the table.
2. Compact the whole database .
This will automatically reset the autoincrement value back to 1.