By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,953 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

DataBase Repair

P: 46
Hi all.I am facing one error using the repair database tool
I have a access database created on 97 version.when i tried to repair the database using the utilities tools,its giving me a message

"the changes you requested to the table were not successfull 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"

My table contain one field with autonumber and indexed property set to
Yes (No Duplicates) and rest all colums in text datatype with Indexed(Yes duplicates) property.

Why is this error coming.Can any one pls give me advise on this.Thanks in advance


Regards
Dilip
Dec 17 '07 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
Hi all.I am facing one error using the repair database tool
I have a access database created on 97 version.when i tried to repair the database using the utilities tools,its giving me a message

"the changes you requested to the table were not successfull 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"

My table contain one field with autonumber and indexed property set to
Yes (No Duplicates) and rest all colums in text datatype with Indexed(Yes duplicates) property.

Why is this error coming.Can any one pls give me advise on this.Thanks in advance


Regards
Dilip
Usually that error means you have a related field (known as the foreign key) in another table that is set to No Duplicates when it should be set to inexed/Duplicates Allowed. The table with the foreign key is generally the many side of a one-to-many relationship with the primary table.
Dec 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.