I have a table(new) in access that I am appending to another table(old) the new table has a id field that is key and set to index not allow duplicates. when I run the query I get key violations and no records are appended. I am not seeing any duplicates in the new table.
both tables have their key field set to long integer, general number with 0 decimal places.

I can't figure out why I am getting key violations, any ideas?

thanks, Arnold