Database Starts at 22

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

Guest

Many times when I create a new database and I click to have Access set a
primary key for me, it then starts at the number 22 for the auto number
instead of 1. Can anyone tell me why this is or what I'm doing wrong.

Thanks
 
Nothing. Just remember that autonumbers are only guaranteed to be unique if
used as a primary key. You can not depend on them be sequential or even
starting at a certain number. If the numbers must be sequetial and start at
1, an autonumber is not the right choice.
 
In
Jerry Whittle said:
Nothing. Just remember that autonumbers are only guaranteed to be
unique if used as a primary key. You can not depend on them be
sequential or even starting at a certain number. If the numbers must
be sequetial and start at 1, an autonumber is not the right choice.
Click to expand...

On the other hand, if autonumbers are starting at 22 for most tables,
something a bit odd is going on. While the value of the autonumber
itself means nothing, an autonumber would normally start at 1 when you
begin to enter the first record for a brand new table. Maybe
chicagoteacher is always performing some series of steps that repeatedly
dirties and then clears a new record.
 
Good point. I was going to suggest deleting all records in that table. Then
doing a compact and repair to see if it resets the initial autonumber back to
1.
 
Back
Top