Autonumber suddenly reverts to earlier numbers

  • Thread starter Thread starter Robbin
  • Start date Start date
R

Robbin

I have a table with a autonumbered, primary key Id field with 500 some
records. Yesterday, I had to "detect and repair" my office suite. Now my
table wants to autonumber new records from #98 (which is already used). Is
there anything I can do short of manually attempting to add some 400 new
records, forcing the number to increase to 500+?

Thank you so much!
 
Try a compact/repair.
In Access 2007:
Office Button | Manage | Compact/Repair
In older versions:
Tools | Database Utilities | Compact/Repair

If that doesn't solve it, you can use this utility:
Fixing AutoNumbers when Access assigns negatives or duplicates
at:
http://allenbrowne.com/ser-40.html
 
Try this on a copied table first...as always

Open the table in design view,
Change the Autonumber field to Datatype: Number
Rename it to something (ID1) ,
Add a new field & Name it the Original Autonumber field
Set the Datatype to Autonumber

It should auto populate

Is this what you were looking to do?
 
Back
Top