title: autoincrement in access sql is not working
body: <p>How can I create a table with autoincrement in access. Here is what I have been doing but not working.</p>
  
  <pre><code>CREATE TABLE People_User_Master(  
      Id INTEGER primary key AUTOINCREMENT,
      Name varchar(50),
      LastName varchar(50), 
      Userid varchar(50) unique,
      Email varchar(50),
      Phone varchar(50),
      Pw varchar(50),
      fk_Group int,
      Address varchar(150)  
  )
  </code></pre>