title: Creating a table by using C# and MS Access SQL
body: <p>I am trying to create a table in my database by I am being told that there is an error in syntax of my SQL. And I can't really tell where.</p>
  
  <pre><code>objOleDbCommand.CommandText = "CREATE TABLE PersonalData (" +
      "[DataID] AUTOINCREMENT NOT NULL PRIMARY KEY ," +
      "[Type] VARCHAR(40) NOT NULL ," +
      "[URL] VARCHAR(40) NOT NULL ," +
      "[SoftwareName] VARCHAR(40) NOT NULL ," +
      "[SerialCode] VARCHAR(40) NOT NULL ," +
      "[UserName] VARCHAR(40) NOT NULL ," +
      "[Password] VARCHAR(40) NOT NULL";
  
  objOleDbCommand.ExecuteNonQuery();
  </code></pre>