title: is there TRUNCATE in Access?
body: <p>I have a table in an Access database with an autonumber field.</p>
  
  <p>When I delete all the records from the table, the autonumber remembers the last number.</p>
  
  <p>Does Access have something similar to SQL Server's <code>TRUNCATE TABLE MyTbl</code>?</p>
  
  <p>If not, how to start with 1 after I delete the table's records?</p>