Click here to Skip to main content
13,195,379 members (61,887 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
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 21:35pm
Comments
phil.o 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
Madhuri Patil 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
 
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)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web02 | 2.8.171019.1 | Last Updated 24 Jan 2013
Copyright © CodeProject, 1999-2017
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