MS-Access inserting record in a table will create duplicated values

Asked By 1290 points N/A Posted on -
qa-featured

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.

The changes you requested to the table were not successful

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.

SHARE
Best Answer by patricia_xx
Answered By 0 points N/A #122669

MS-Access inserting record in a table will create duplicated values

qa-featured

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.
Best Answer
Best Answer
Answered By 0 points N/A #122668

MS-Access inserting record in a table will create duplicated values

qa-featured

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.

Answered By 0 points N/A #122671

MS-Access inserting record in a table will create duplicated values

qa-featured

Hello Paulartney

As well these solutions also visit this Techyv page for more information about this issue.

Changes you requested to the table were not successfull

Login/Register to Answer

Related Questions