title: Access SQL - ALTER COLUMN to AutoNumber?
body: <p>How can you alter a table in MS Access using SQL to change a data type to AutoNumber?</p>
  
  <p>I have tried to following with no success</p>
  
  <pre><code>ALTER TABLE PERSON ALTER COLUMN PERSON_ID Integer PRIMARY KEY counter
  );
  ALTER TABLE PERSON ALTER COLUMN PERSON_ID Integer PRIMARY KEY AUTONUMBER
  );
  ALTER TABLE PERSON ALTER COLUMN PERSON_ID Integer PRIMARY KEY AUTOINCREMENT
  );
  </code></pre>
  
  <p>Each time I get the same issue "Syntax error" and it highlights the last word in the SQL.</p>