Unable to access my MS Access Data Base file

Asked By Karen G Bedard 0 points N/A Posted on - 09/10/2012

Hello guys,

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.

 

                                                OK        Help

How do I view the contents of this file again?

Can anyone please help me?

Thanks.

• Status: Open
• Question Views: 822
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By Rikki Martin 0 points N/A #134739

Unable to access my MS Access Data Base file

Hi,

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

Thanks

About Rikki Martin

Questions
1

Answers
12

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 09/10/2012
• Question Category: Misc Software