Access: Change the Start Value of an AutoNumber Field

Posted July 17, 2004 by Lilliabeth in Microsoft Office

The following Tech-Recipes tutorial describes changing the start value of an AutoNumber field

Create your table with an AutoNumber type field, but do nor enter any records. Then create another table with only a single Long Integer Number type field. This field must have same name as the AutoNumber field in the first table. Enter one record in the second table that is a number one less than the required start of the AutoNumber for the first table.
Now, create an append query to append the record in the second table to the first table and run the query. You can now delete the second table and begin entering your data into the first table.

The Conversation

Follow the reactions below and share your own thoughts.