Asked By
paulartney
1290 points
N/A
Posted on - 08/02/2011
Great day to all,
My post here is an issue about MS Access error. When I tried to insert a new record in a table, and this table has an auto number field, an error message appeared on my screen.
Please see below the error message I pasted.
Microsoft Access
The changes you requested to the table were not successful because theyÂ
would create duplicated values in the index, primary key, or relationship.Â
Change the data in the field or fields that contain duplicate data, remove theÂ
index, or redefine the index to permit duplicate entries and try again.
                       OK           Help
Even after much analysis of the error message, I still have no idea on what went wrong with my process that led to this error. This is also my first time to see this error.
Please help me solve this issue.
All your suggestions and thoughts will be highly appreciated.
Thanks a lot in advance.
Answered By
Kelvin14
0 points
N/A
#122669
MS-Access inserting record in a table will create duplicated values
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship.
Change the data in the field or fields that contain duplicate data, remove the index or redefine the index to permit duplicate entries and try again.
Hope it will work.
Â
Thanks.
MS-Access inserting record in a table will create duplicated values
The reason for the above stated error might be one of the fields requiring a unique value. Meaning the field is indexed with "No Duplicates" and you are entering a value that would result in a duplicate index.
What you can do to resolve the issue is to change the column to allow duplicates or stop it from being the primary key field to allow duplicates to be placed in that field.
Another thing that needs to be checked is table relationships. You should avoid using cascading updates in your table relationships, but instead run the update from a quick ad-hoc relationship query.
