Access 2010 Compact & Repair breaks autonumber seed if index is descending
While this is very unusual having more than 1000 records in an Access 2010 MDB with the autonumber index in descending sequence a compact and repair loses the seed and the next record inserted fails.
Note this is the Microsoft partner forums so if you haven’t registered as a partner you won't see this.
I have reproduced this behavior myself.
(I sure would like to know why 1000 records is required to repro this though. <smile>)
This behavior also happened in Jet 4.0 for a while. AutoNumber field duplicates previous values after you compact and repair a database