title: MS Access 2007 Append query trouble
body: <p>I have an append query that is trying to append some records to one of my tables. However, I am getting an error that says “didn’t add 1200 records due to key violations.” 1200 is the total number of records I am trying to append. I don’t understand why I am getting this error because all of my columns in the destination table allow duplicates (even though this append query doesn’t duplicate any information), and if I copy the structure of the table and append the records to that, everything works.</p>
  
  <p>The problem seems to be that I am appending data to a table which already has existing data. Can someone please offer some suggestions for how I can work around this? </p>
  
  <p>Thanks</p>