Checking for key violations in Access append query

Question

I'm trying to append a table to another table, and I receive a key violation error.

"Microsoft Access can't append all the records in the append query. Microsoft Access set 0 field(s) to Null due to a type conversion failure, and it didn't add 26 record(s) to the table due to key violations, 0 record(s) due to lock violations, and 0 record(s) due to validation rule violations. DO you want to run the action query anyway?"

How can I tell Access where SPECIFICALLY these key violations are occurring? It's hard for me to scroll through this and resolve everything.

Need the table schemas and the query to even start giving you an answer. Should be easy to identify the bad guys though. — Tony Hopkinson

Dalen Dalen · Accepted Answer · 2012-10-16T22:00:06

you can detect the 26 conflicts with a simple inner join:

SELECT *
FROM tableA
   INNER JOIN tableB
      ON tableA.keyColumn = tableB.keyColumn

Checking for key violations in Access append query

2 Answers