During testing a database design you may find that you have included a lot of dummy values, but then want the counters to be reset when you deliver the application.
To solve this problem try the following:
After deleting your dummy data, compact the database, this will reset counter fields to the next sequential value, e.g. for a table with no records this will be zero but if the table still contains data then it will be 1 + the highest value in the table.
There are further alternatives to this process, however this remains the simplest.
If you wish to start the counter field at a different number (for example 1000) then please see the Microsoft Access Help files for:
Change the starting value of an incrementing AutoNumber field or see the following article: