How to restart counting from 1 after erasing table in MS Access?

Question

I have table in MS Access that has an AutoNumber type in field ID

After inserting some rows, the ID has become 200

Then, I have deleted the records in the table. However, when I tried to insert a new row, I see that the ID starts with 201

How can I force the ID to restart with 1, without having to drop the table and make new a new one?

Answer 1

In Access 2010 or newer, go to Database Tools and click Compact and Repair Database, and it will automatically reset the ID.