title: Key violation when running append query the 1st time, but NOT the 2nd time
body: <p>I am getting an error that says that there is a key violation when I run an append query using VBA. However, I'm not doing anything to change the primary key of the table so why would there be a key violation?</p>
  <p>Here's the strange part - the first time I run the append query, I get this key violation error. But when I run it again immediately, i.e. without doing ANYTHING ELSE, it works fine.</p>
  <p><strong>The SQL string:</strong></p>
  <pre><code>INSERT INTO tblQuoteVendors (QuoteID, CompanyID, ContactID)
  VALUES (360, 236, 491);
  </code></pre>
  <p><strong>Table Schema:</strong></p>
  <pre><code>Field Name    Datatype
  ID            Autonumber
  QuoteID       Number
  CompanyID     Number
  ContactID     Number
  VendorQuote   Short Text
  </code></pre>
  <p><strong>Table relationships:</strong></p>
  <h3>Screenshot of table relationships</h3>
  <p><img src="https://i.stack.imgur.com/Sd2MR.png" alt="Screenshot of table relationships" /></p>