Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#3.0
Hi,
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"
 
Regards
Balamurugan
Posted 17-Jan-13 22:35pm
Comments
phil.o at 18-Jan-13 3:40am
   
Without seeing your code for updating it will be quite impossible to help you.
Balamurugan1989 at 18-Jan-13 3:49am
   
Just give me a solution for this error.What are the ways to solve this error.
Deenuji at 18-Jan-13 3:49am
   
do u creating any primary key or u set any index value for this table????
Balamurugan1989 at 18-Jan-13 3:52am
   
No i'm not creating primary key
Madhuri Patil at 18-Jan-13 3:56am
   
give your update query for more info..
Deenuji at 18-Jan-13 3:58am
   
refer below link man......
Balamurugan1989 at 18-Jan-13 5:14am
   
U give your solution...
Rate this: bad
good
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.
  Permalink  

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



Advertise | Privacy | Mobile
Web03 | 2.8.150302.1 | Last Updated 24 Jan 2013
Copyright © CodeProject, 1999-2015
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