Error in automatic counter after compacting

[Montemontgo]

After compacting my Access2000 database it usually is impossible to add new records. The automatic counter does not continue with a new value but seems to have "forgotten" some of the recently added records and tries to use a value that is already allocated. After pressing <ESC> the next value is applied and so - after adding and escaping the appropriate times - it finally reaches a valid new value and the record is accepted. Ugly workaround. Any known solution?

 

[DJN]

Is the automatic number as you call it an autonumber?

 

[Montemontgo]

Yes, it is.