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.

Reset

 

Databases in production

http://support.microsoft.com/kb/812718

 

 

About these ads

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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