Changes you requested to the table were not successful

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

Hi guys!

I have a problem using Microsoft Access at work.
 
An error message appeared on my screen, I pasted below the whole message
 
 
Microsoft Access
 
Microsoft changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the date in the field or fields that contain duplicate date data, remove the index, or redefine the index to permit duplicate entries and try again.
 
That is why I asked somebody to do it for me. but after doing so, the same error message appeared on my screen. He did it again to ensure all things were done properly, but the same error message appeared.
 
I am now wondering, are there any problem aside from redefining the index to permit duplicate entries issue? Please post some comments on my problem.
 
Thanks.
SHARE
Answered By 0 points N/A #97986

Changes you requested to the table were not successful

qa-featured

Not successful changes because of duplicate values of the index.

Based on the warning message I was prompted by the 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.”  I mean that there is a problem creating or updating data on the primary key or the indexed field.

If your system, implementation requires unique values in a field as you need to change the data input. The message tells you that the data you have entered is already there. Like for instance, you have the index field with no duplicates named Employee ID.

When you have already entered the employee ID 0001 for John Doe, on the next input you should not use the 0001 again for Peter Park because it would generate the error message like what you have encountered. You should use the 0002 for Peter Park’s Employee ID.

If your system does not require a unique field in that table, change your field index property to “Index (duplicate Ok) “. This will allow you to use duplicate values in an indexed field. Or if index is not needed for those fields, remove the index. Set the Indexed property to No.

And if it is really required to have indexed and no duplicates, and you cannot avoid the possibilities for the user to generate a duplicate values of the field, trap the error raised in your program code (if you have one) then once the error was raised, give the user a chance to change the field with duplicate values so that he may not re-type the entire data.

Login/Register to Answer

Related Questions