[AccessD] Initial value of an ANPK

Hi Arthur

Just search the archive and look what Ken wrote (and it works, I did a test in A2003):

I use a Data-Definition SQL statement:

ALTER TABLE TableName ALTER COLUMN AutoField COUNTER (1,1); 

The first number is the starting value, and the second is the increment.

This works for A2K and later.

/gustav

>>> fuller.artful at gmail.com 06-12-2007 19:36 >>>
I seem to recall that there's a way to specify the starting value for an
AutoNumber PK but I can't remember how to do it. Anyone?

TIA,
Arthur