Starting an AutoNumber Field in MS Access with a Number You Want

In Microsoft Access tables, the AutoNumber field type allows you to automatically assign a unique sequential number to each row in a table. AutoNumber fields are often used as the Primary Key, since they are unique and permanent.

By default, AutoNumber begins with 1. However, you may want to start with another number. Here's an easy way to set the AutoNumber at a number higher than 1.

 

(NOTE: This tip was revised on March 26, 2010 to fix a typo in the SQL syntax.)