Reset Microsoft Access 2010 Autonumber

For Databases in Development (pre-production)

If you have developed a database and used autonumber to fill a field automatically, there is an easy way to reset the number.

Delete the test data in your database’s table prior to placing the database in production.

Close the table and any associated reports and queries.

Select File, Info and Click on the Compact and Repair database.   This will reset the numbers.



Databases in production



About these ads

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s