duplicated primary keys

[harryklein]

Hi,
we have an msaccess database that we use from excel. We write records into it with vba-sql (INSERT INTO) commands.
In the query we don't populate the ID field as it is set to auto number-type and access adds the ID automatically. We use this application since more then a year,
and recently we noticed that that the some records have the same ID. It has about 110000 records and we found 4 duplicates, all created in the last week.


That was a bit shocking. How is it possible? Is there any way to avoid it?
Thank you

[Bulzie]

Are you sure that field is a primary key in the table? You can add an autonumber field without making it the primary key.

[harryklein]

Absolutely good point. I was 100% sure that it is primary key, didn't even think about checking, but you are right, it wasn't set to primary key.
Thank you.

[Bulzie]

Glad I could help.