Warning received about duplicate values, but there are no duplicate values

[Peakwalker]

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 it though.

Any help would be appreciated.

[alcapps]

Is this an access table or linked SQL table?

[alcapps]

After thinking about it for a moment it sounds like a index issue. Remove all indexes on that table. Then try adding a record manually.

[Peakwalker]

It is an Access table. How do I remove an index on a table?

[Peakwalker]

Thank you!!! I found instructions online about removing indexes and it did the trick. Thanks so much

[alcapps]

Great! Glad that you got it working.