Changing Starting number in autonum column

[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

 

[Arvin Meyer]

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