title: Using Autonumbering in Access - INSERT statements
body: <p>I'm having trouble running an <code>INSERT</code> statement where there's an autonumber as the PK field. I have an Auto-incrementing <code>long</code> as the Primary Key, and then 4 fields of type <code>double</code>; and yet Access (using ADO) seems to want five values for the insert statement.</p>
  
  <pre><code>INSERT INTO [MY_TABLE] VALUES (1.0, 2.0, 3.0, 4.0);
  &gt;&gt; Error: Number of query values and destinations fields are not the same.
  
  INSERT INTO [MY_TABLE] VALUE (1, 1.0, 2.0, 3.0, 4.0);
  &gt;&gt; Success!!
  </code></pre>
  
  <p>How do I use Autonumbering to actually autonumber?</p>