Unable to access my MS Access Data Base file

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #134739

Unable to access my MS Access Data Base file

qa-featured

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

Related Questions