Access: Change the Start Value of an AutoNumber Field
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.
Follow the reactions below and share your own thoughts.