AutoNumber

  • Thread starter Thread starter Dave B
  • Start date Start date
D

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??
 
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??
Click to expand...

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
 
Back
Top