Changing the starting value of an AutoNumber field

To change the starting value of an AutoNumber field, create a new query and copy the following code into it.  Replace "replaceWithTable" with your table name, and "replaceWithAutoFieldName" with the AutoNumber field name to be reset.  When you run the query you will be prompted to enter a new starting value.  

PARAMETERS [Enter starting value:] Long;
     INSERT INTO replaceWithTable (replaceWithAutoFieldName )
          SELECT [Enter starting value:] AS Expr1;

Click Yes when you are asked to allow Access to append a row.