Click here to Skip to main content
13,554,862 members
Rate this:
Please Sign up or sign in to vote.
See more:
When i'm updating the same value for 2 tables i'm facing this error ,How to solve this error.
"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"

Posted 17-Jan-13 21:35pm
User-890501 18-Jan-13 3:40am
Without seeing your code for updating it will be quite impossible to help you.
Balamurugan1989 18-Jan-13 3:49am
Just give me a solution for this error.What are the ways to solve this error.
Deenuji 18-Jan-13 3:49am
do u creating any primary key or u set any index value for this table????
Balamurugan1989 18-Jan-13 3:52am
No i'm not creating primary key
User-7725264 18-Jan-13 3:56am
give your update query for more info..
Deenuji 18-Jan-13 3:58am
refer below link man......
Balamurugan1989 18-Jan-13 5:14am
U give your solution...
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

This error occurs due to not adding datatype in a right way in Access.We need to add the datatype in a right way.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.180515.1 | Last Updated 24 Jan 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100