I recently read article Q291162 that explains a bug in Access 2002 about autonumber fields not generating the correct next number. After I compacted the database, I had that problem where my highest id was 12677 and when I added a new record, Access assigned 267 as the next number. This article says that the problem was fixed in the latest service pack....I have the latest service pack and I still have the problem.
I have version 4.0.8618.0 of the culprit file (msjet40.dll)
Help!