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

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.

• Status: Open
• Question Views: 1555
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by patricia_xx

Go To Solution

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.

About Kelvin14

Questions
0

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/02/2011
• Question Category: MS Access

Best Answer

Best Answer

Answered By patricia_xx 0 points N/A #122668

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.

About patricia_xx

Questions
0

Answers
4

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/04/2011
• Question Category: MS Access

Answered By Keith S Whitmire 0 points N/A #122671

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

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

About Keith S Whitmire

Questions
8

Answers
24

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/03/2014
• Question Category: MS Access