AutoNumber in Access 2010 breaks
Posted on 2011-02-15
MS Access split application (.mde, .mdb)
5 year history
Includes a table which has a field which is the Primary key and is AutoNumber data type.
Just 3 sites running on MS Access 2010. All using .mdb vs .accdb file format.
One site only is experiencing dysfunction of the AutoNumber field. Ie. It does not try to use the next available value. It tries to use a previously used value causing error of ‘duplicate value in index’.
We have reset the value AutoNumber attempts to use successfully. Unfortunately, the problem recurs after a week or so of use.
Is this a known problem with MS Access 2010? I do not find this as reported problem.