Access: Change the start value of an autonumber field

Contributed by Lilliabeth July 17, 2004  
Tagged: Microsoft Office

Create your table with an AutoNumber type field, but don’t 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.