Corrupted AutoNumber Key

[jaaret]

What factors cause the AutoNumber Key to become corrupt? On three occurances now the AutoNumber field has reset to a number lower than the maximum in the table. If the maximum AutoNumber key is 8013, a new record will try to assign 8005 as the key which, of course, causes an error. In one instance the new record tried to assign a much lower number, such as 5016 to the new record. The database this is occurring in has three concurrent users.

Thanks for your insights in advance,
Jaaret

 

[jrbarnett]

See faq700-184 and faq181-1023

John

 

[RoyVidar]

Here are some explanations, and fix

http://allenbrowne.com/ser-40.html

Roy-Vidar