My AutoNumber is Duplicating

[Tim]

I have a heavily linked database with a backend that has been running OK for
about 3 years. However, I now have an AutoNumber field that is duplicating
old values when I enter and link in new data. The table shows about 15
duplicated values in the AutoNumber field and I am not getting any errors. I
have tried to change the data type and overwrite the numbers, but the table
is linked and Access won't allow the changes.
Any suggestions on how I could force the AutoNumber back to the maximum
value, or change the field so I can manually re-number, would be
greatlyappreciated.

 

[Peter Doering]

I have a heavily linked database with a backend that has been running OK for
about 3 years. However, I now have an AutoNumber field that is duplicating
old values when I enter and link in new data. The table shows about 15
duplicated values in the AutoNumber field and I am not getting any errors. I
have tried to change the data type and overwrite the numbers, but the table
is linked and Access won't allow the changes.

Any suggestions on how I could force the AutoNumber back to the maximum
value, or change the field so I can manually re-number, would be
greatlyappreciated.

http://support.microsoft.com/kb/812718

FYI, autonumber does not imply uniqueness, a unique index on the autonumber
field does.

 

[John W. Vinson/MVP]

I have a heavily linked database with a backend that has been running OK for
about 3 years. However, I now have an AutoNumber field that is duplicating
old values when I enter and link in new data. The table shows about 15
duplicated values in the AutoNumber field and I am not getting any errors. I
have tried to change the data type and overwrite the numbers, but the table
is linked and Access won't allow the changes.
Any suggestions on how I could force the AutoNumber back to the maximum
value, or change the field so I can manually re-number, would be
greatlyappreciated.

What version of Access? Are all the service packs up to date? This was
a bug - repeatedly! - in a few versions, but it should be fixed by
installing all the service packs in any version.