Changing Starting number in autonum column

  • Thread starter Thread starter Carl
  • Start date Start date
C

Carl

The instructions in Access on changing the starting
number for an Autonum column don't seem to work.

Does anybody know how to do this? For example, have the
autonum column start at 4000 instead of 1.

TIA
Carl
 
In an empty table (let's call it Table1) append a dummy record with a value
of 3999 to the table. The next record will be 4000. After it's written,
delete the dummy record.

INSERT INTO Table1 ( ID, Whatever )
SELECT 3999 AS Expr1, "Dummy" AS Expr2;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top