Microsoft Access changes to the table were not successful

Asked By danseagul 0 points N/A Posted on - 08/11/2011

Hi Techyv people,

While I was working on my inventory encoding task using an application build from Microsoft Access, I met an error message when I saved my work. Please refer below for more details of the error message.

 Microsoft Access

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.

When I received the error message, I don't have any idea on what went wrong. I also asked my office mate, but they haven't experienced this error message ever since. That is why they can't extend any help. I am posting here this error message for me to get some help on this issue. I hope to hear some advices soon. 

Thanks.

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

• Answer Accepted: No
• Question Category: MS Access

Answered By George Flemming 5 points N/A #98097

Microsoft Access changes to the table were not successful

Of course that error would appear because you have created a field and set it as a primary key. Meaning no duplicates are allowed when a field is set as a primary. You must first remove the assigned Primary Key to a field by going to the design view of your table. See figure 1.

Figure 1.

If the field has an icon of key on the left side, click the icon key found on the menu bar labeled “Primary key” to remove the restriction for duplicate entries. Another instance is that under the field properties of the Field Name on the “General” tab you have accidentally set the Indexed settings to “Yes (No Duplicates)”. Refer to figure 2.

Figure 2.

Change it to “No” like the one shown on figure 2. You can also select the “Yes (Duplicates OK)” You can now save name, numbers etc. Even if your database had it already.

About George Flemming

Questions
0

Answers
50

Best Answers
20

• Vote Up 0 Vote Down

• Posted on - 08/11/2011
• Question Category: MS Access