Key Violation -- Append Query Error

  • Let me start by saying that I'm not good at Access...I prefer Excel, therefore this may be a dumb question...

    I am attempting to load data to a table through an append query, but I keep getting an error stating that Access didn't add 21 records due to a "key violation error". There is Primary Key in the table, but the 21 records that I am attempting to append are all unique. Is there some easy fix that anyone can think of??? :yikes:

    Thanks for any assistance.


  • Re: Key Violation -- Append Query Error

    Found the error...there were two fields that I was loading as null values. Those nulls were causing the error.

    Thanks for the reply!


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!