Warning: Invalid argument supplied for foreach() in /home/techrecipes/public_html/wp-content/themes/techrecipes/header.php on line 77

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.

  • Estela

    It worked! THANK YOU!

  • DJG

    Thank you again!

  • Dustin

    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.”