Why does my autonumbered field not start at 0?

L

Laura

I have created a table and as all of the other fields could potentially have
repeats I am using a numbered ID as the primary key, this however is not
starting at zero it keeps starting at 22? Can anybody please help?
 
A

Al Camp

Laura,
If your table is empty, before adding any records to your table...
Compact the database.
Then the first record you enter should be 1.
 
J

Jeff Boyce

Laura

If your Primary Key is used solely for identifying the record, does it
matter whether it starts at 1 or 22 or 12345?

Regards

Jeff Boyce
<Office/Access MVP>
 
L

Larry Daugherty

Hi Jeff,

That's one reason for my frequent rant that Autonumber datatypes
should absolutely, positively be used for nothing but surrogate keys
and that they should never, never, never be seen by humans.
 
Top