title: Checking for key violations in Access append query
body: <p>I'm trying to append a table to another table, and I receive a key violation error.</p>
  
  <blockquote>
    <p>"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?"</p>
  </blockquote>
  
  <p>How can I tell Access where SPECIFICALLY these key violations are occurring? It's hard for me to scroll through this and resolve everything.</p>