title: How to reset an Access table's AutoNumber field? (it didn't start from 1)
body: <p>I have a <code>INSERT INTO ... SELECT</code> statement that copies data from one table to another.</p>
  
  <p>The thing though is, the AutoNumber column value in the second table started from the last number in the first one.<br>
  Meaning the count of first table is 2000, then, the second table started from 2001.</p>
  
  <p>Using an Access database, how to reset this value?</p>