title: auto increment in ms access by sql query
body: <p>I've tried this query in MS Access SQL query section</p>
  
  <pre><code>create table demo(
    deomid long not null identity(1,1),
    name varchar(200),
  
    primary key(userid)
  )
  </code></pre>
  
  <p>I also have used <code>identity , autonumber , autoincrement , autoincrement(1,1) , auto_increment</code> instead of <code>identity(1,1)</code> in the above query.</p>
  
  <p>Every statement produces error saying that syntax error in create table statement...
  Please tell what is proper way to auto increment a long field.</p>