My AutoNumber is Duplicating

  • Thread starter Thread starter Tim
  • Start date Start date
T

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.
 
Tim said:
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.
Click to expand...
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.
Click to expand...

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

FYI, autonumber does not imply uniqueness, a unique index on the autonumber
field does.
 
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.
Click to expand...

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.
 
Back
Top