title: MS Access Create Table with Autoincrement and default date
body: <p>I try to create MS Access Table with autoincrement ID and Default Date field, but next query always says "Syntax error in CREATE TABLE statement.":</p>
  
  <pre><code>CREATE TABLE Table1
  (
      [ID] AUTOINCREMENT,
      [Email] TEXT(255),
      [ProductID] NUMBER,
      [DateCreate] DATETIME,
      [DateSend] DATETIME
  );
  
  
  ALTER TABLE Table1
  ALTER [DateSend] DATETIME DEFAULT NOW() NOT NULL;
  </code></pre>
  
  <p>Who can help me to fix that query. Thanks!</p>