key violation error

[MarkGardner]

I am using an append query and get a "key violation" error. Everything that I have read indicates that I probably have some duplicate records somewhere. I am confused as to which of the two tables has a duplicate record. I think that it should be the target table.

I have eyeballed both target and source tables and have not found any duplicates. I have run a query to search for duplicates in both tables, but they come up empty as well.

I have changed the indexed field to "Yes(no duplicates) in the properties grid at bottom of screen. It does not work any better.

I am not sure if I need to search more for duplicates or change my properties. I am at a loss of where I need to look for a solution. Could it be something other than a duplicate record?

PS2

By the way, I do not do SQL.

Thanks.

Mark

PS. Or does it mean that by doing the action it would have created a duplicate record after the append? For example could one record already already exists in the target and an identical in the source? And by performing the append(that it blocked) it would have created a duplicate in the target table. And not necessarily be a duplicate in the same table(target or source)? Target has over 833 records and source has over 200 records> How do I track down that possibility?
MG

PS2
I solved it. I went in and temporarally changed the indexed field to Yes, (allow duplicates.). I then went ahead and ran the query. I fugured that if it were in two different tables, I would never find it, since I ame not sure how to do a comparison query between two different tables. Then after I completed the append queries, I went ahead and did comparsion query and it found the duplicate and I was able to fix the problem. Now the query runs without problems.

MG

 

[MSAccessRookie]

I am using an append query and get a "key violation" error. Everything that I have read indicates that I probably have some duplicate records somewhere. I am confused as to which of the two tables has a duplicate record. I think that it should be the target table.

I have eyeballed both target and source tables and have not found any duplicates. I have run a query to search for duplicates in both tables, but they come up empty as well.

I have changed the indexed field to "Yes(no duplicates) in the properties grid at bottom of screen. It does not work any better.

I am not sure if I need to search more for duplicates or change my properties. I am at a loss of where I need to look for a solution. Could it be something other than a duplicate record?

By the way, I do not do SQL.

Thanks.

Mark

You can get an error on append (although I am not sure it will be a key violation error), when a Column is defined as Required or not Allowing Zero Length while the imported data contains Nulls in that column. Check the data for Nulls.