How do i change the starting value of an AutoNumber field

J

joce

I have set up a new table and want to change the number in the AutoNumber
field. Help only provides directions pertaining to an existing table.
 
G

Guest

Build temp table with a couple of fields. Make the first
field a number field, long interger. Put your starting
number minus one in a record.
Append the one record to your table. Delete the record
you just appended. The next record will be your number.
 
L

Larry Daugherty

Hi,

If you care what the value of an autonumber is then you're miss-using it.
The Autonumber datatype exists solely to generate uniqueness for a surrogate
key. It should never be seen by end users.

If you need to generate a sequence, you must do it with your own code.

HTH
 
Top