How to reset an AutoNumber field value in Access

Applies to: Microsoft Office Access 2007Microsoft Office Access 2003

Summary


This step-by-step article describes how to reset an AutoNumber field value in Access. The AutoNumber field value in Access does not automatically reset when you delete some rows or all rows in a table. To reset the AutoNumber field value and to refresh the AutoNumber value in the referenced table, you must manually perform some tasks.

Note You must back up your database before you perform the steps that follow.

back to top

References


For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
 
209696 How to use an append query to set initial value of an AutoNumber field
 
287756 AutoNumber field is not reset after you compact an Access database