duplicate value error message - new issue

[dab1477]

After successfully running a database for 2 years, suddenly as of 1/20/2010,
I get the following error message after data input into a form, "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".
I am inputing about 13 values into a form that feeds a master table. The
table can have duplicate values, but NOT within the same date and shift
input, I have reviewed the ID or Primary key of the 11644 records within the
table and have found no duplicates. As this database has worked successfully
for 2 years, I doubt that someone has, or would know how, to address the
database relationships. Can somone point me in the right direction please?
I'm an intermediate Access junkie and am now frustrated. Thanks for any help
you can provide,

 

[Dorian]

You need to record all of the data being used to update the table and then
verify if any indexed column (not just the primary key) contains duplicate
data.
You could remove the relationships to the table temporarily to isolate
whether it is a related table causing the problem (and could do one at a time
to isolate which related table).
The divide and conquer approach is needed to isolate the issue.
Obviously do all of this in a COPY of your database.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".