Hi all,
the following query does not work :
(I am using a generic database access tool to create tables and enter
data into an mdb file)

CREATE TABLE Customers
(
  CustID      autoincrement(10,10)    not null ,
  CompanyName text(75)    NULL,
  ContactName text(75)    NULL,
  CustType    text(10)    NULL,
  Area        text(50)    NULL,
  Address     text(255)   NULL,
  City        VARCHAR(50)    NULL,
  State       VARCHAR(50)    NULL,
  PINCode     VARCHAR(10)    NULL,
  Phone       VARCHAR(50)    NULL,
  Mobile      VARCHAR(50)    NULL,
  Fax         VARCHAR(50)    NULL,
  Email       VARCHAR(80)    NULL,
  CurrCredit  DECIMAL(18,2)  NULL,
  primary key (CustID)
);

The error from Access 2000 is:
An error occurred when executing the SQL command:
CREATE TABLE Customers
(
  CustID      autoincrement(10,10)    not null ,
  CompanyName text(75)    NULL,
  ContactName text(75)    NULL,
  CustT...

[Microsoft][ODBC Microsoft Access Driver] Syntax error in field
definition. [SQL State=37000, DB Errorcode=-3553]

Total execution time: 0.0s
(Statement 22 of 22 finished.)

I thought maybe Area is a keyword for Access 2000, so I changed the
column name to MyArea - but same result.

CustType surely could not be a keyword.

Then I tried making all text fields as text(N), no luck
Then all text fields as Varchar(N), still no luck.
Finally, deleted the column MyArea, still no luck.

BTW, both text(N) and Varchar(N) work perfectly fine - I tried that out
with another table.

Any clues what is wrong?

TIA,
JS