Microsoft Access:  Change the Starting Value of an AutoNumber Field

1. Create table with an AutoNumber type field. Do not enter any records.
2. Then create another table with only a single Long Integer Number type field. Ensure this field has the same name as the AutoNumber field in the first table.
3. Enter one record in the second table that is a number one less than the required start of the AutoNumber for the first table.
4. Create an Append Query to append the record in the second table to the first table and run the query.
5. Now, delete the second table and begin entering your data into the first table.

If you have any questions regarding this tip or need help implementing it in your own projects, contact Ranelle Maltas, Application Support Associate, at 472-0585 or e-mail at rmaltas2@unl.edu.