I am using Access 2010, and have come across this problem before which miraculously solved itself, but now it's come up
again. The db is about 800MB in size, and the table I am using has just over 1000 records in it.
I have a list of samples, each with a unique id. When I go to add a new sample to the list, it tells me it can't do it as it
would create duplicate values in the index, primary key, or relationship. I know for certain it is not a duplicate number,
and I can put in completely random values and it always gives the same message. I normally add values to the table using an
append query, but whether I use the query or try to type manually, it won't let me add the field. I have also removed the
primary key from the sample number field, and it still gives the same message.
I am wondering if it is a relationship issue, I use the table in a query but it has worked fine for months and so I don't
know why it would all of a sudden stop working now. If it is a relationship issue I wouldn't know how to start looking for
Any help would be appreciated.