How do i change the starting value of an AutoNumber field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
Back
Top