MS Access split application (.mde, .mdb) developed using Access 2003.
300 sites, 5 year history
Includes a table which has a field which is the Primary key and is AutoNumber data type.
Using .mdb (2002-2003) vs .accdb (2007) file format.
After using access 2010 sp1 compact and opening again in 2010 sp1 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’.
Do not see this problem when using access 2007 compact.
FYI, we see same result if we convert to accdb.