Auto numbering doesn't begin with a 1. Starts at 22

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

Guest

I am working in Access 2003 using AutoNumber as a Primary key in a table. My
problem -- Autonumbering begins at 22, not 1. Where can I change this to
start at 1? Thanks.
 
why does it matter? an Autonumber is meant to physically identify records to
the *system*, it should not be exposed to the user, or have meaning to the
user. if you're wanting to assign consecutive number to records that are
meaningful to the user, recommend you do it programmatically - not with
Autonumber.

having said that, Autonumber normally resets when the database is compacted.
it's also possible to run an Append query to add a record to the table with
a specified number in the Autonumber field - 1 less than the number you're
after - and records added after that should build on that "forced" number.
again, keep in mind that an Autonumber does not and cannot guarantee
consecutive number assignment.

hth
 
Back
Top