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.

The Conversation

Follow the reactions below and share your own thoughts.

3 Responses to “Access: Change the Start Value of an AutoNumber Field”

  1. June 14, 2011 at 10:05 pm, Estela said:

    It worked! THANK YOU!

    Reply

  2. June 28, 2011 at 3:57 pm, DJG said:

    Thank you again!

    Reply

  3. July 16, 2013 at 1:26 pm, Dustin said:

    How do you do this part? “Now, create an append query to append the record in the second table to the first table and run the query.”

    Reply

Leave a Reply