Changes you requested to the table were not successful

Changes you requested to the table were not successful

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.