title: how to create decimal field in access database?
body: <p>I have used bellow code to create decimal column in accessdb, But when I execute the code it returns <code>field definition error</code></p>
  
  <pre><code>dbname = r'C:/Users/Dhana/Documents/NewDB.accdb'
  accApp = Dispatch("Access.Application")
  dbEngine = accApp.DBEngine
  workspace = dbEngine.Workspaces(0)
  
  dbLangGeneral = ';LANGID=0x0409;CP=1252;COUNTRY=0'
  newdb = workspace.CreateDatabase(dbname, dbLangGeneral, 64)
  
  newdb.Execute("""CREATE TABLE AAA (ID COUNTER, Field1 DECIMAL(10,3));""")
  </code></pre>
  
  <p>But I am able create the decimal field through access database interface(GUI). Please help me to solve this issue.</p>