Microsoft Access changes to the table were not successful

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

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.

Change the data in the field or fields that contain duplicate data

 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.

SHARE
Answered By 5 points N/A #98097

Microsoft Access changes to the table were not successful

qa-featured

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.

Primary Key

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.

Remove duplicate entries

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.

Related Questions