N/APosted on - 09/10/2012
I have a problem. I am unable to access my MS Access DataBase file.
When I try to open it, an error prompt pops-up saying:
Microsoft Office Access
The changes you requested to the were not successful because they would create duplicate values in the
index, primary key, or relationship. Change the data in the fields or fields that contain duplicate data, remove the
index, or redefine the index to permit duplicate entries and try again.
How do I view the contents of this file again?
Can anyone please help me?
Unable to access my MS Access Data Base file
1. In order to resolve this issue. You have to identify the duplicate values in your tables you had duplicate
primary Keys that’s why this error occurs.
2. Check your tables. You've got an index set to 'no duplicates' and you're trying to enter a value which
would result in an index being duplicated.
3. After this check your Relationship between tables.
You can get help to do this from official Office site