Why does my autonumbered field not start at 0?

[Guest]

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?

 

[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.

 

[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>

 

[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.