title: VB.Net OleDbException "Syntax error in field definition"
body: <p>I'm trying to create a table in an Access database through an OleDbCommand in VB.Net with the following SQL: </p>
  
  <pre><code>CREATE TABLE InTemp (Month DATE, Description TEXT(255), Cost DOUBLE, Patron TEXT(255));
  </code></pre>
  
  <p>The code works fine in Access, but running it in VB.Net returns the OleDbException "Syntax error in field definition".</p>
  
  <p>Full VB code:</p>
  
  <pre><code>Dim con As New OleDb.OleDbConnection
  con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = " + DatabaseLocale
  con.Open()
  Dim createInTemp As New OleDb.OleDbCommand("CREATE TABLE InTemp (Month DATE, Description TEXT(255), Cost DOUBLE, Patron TEXT(255));", con)
  createInTemp.ExecuteNonQuery()
  </code></pre>
  
  <p>I know there's no problem with the connection as it works elsewhere in my program.</p>
  
  <p>Any help gladly appreciated!</p>