AutoNumber

[Dave B]

I have a table in Access with 45878 entries. When I try to enter a new
record, the AutoNumber for the PersonID says 31640, but there already is a
31640! Why does Access think 31640 should be the next number when 45879
should be??

 

[Bruce M. Thompson]

I have a table in Access with 45878 entries. When I try to enter a new

record, the AutoNumber for the PersonID says 31640, but there already is a
31640! Why does Access think 31640 should be the next number when 45879
should be??

Take a look at the following MS Knowledge Base articles and see if one might
apply to your problem (the second is really the same as the first, but is for
Access 2002):

ACC2000: AutoNumber Field Duplicates Previous Values After You Compact and
Repair a Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;257408

AutoNumber Field Duplicates Previous Values After You Compact and Repair a
Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;291162