create table in ms-access using cfm file

i created a table in msaccess manually with following details table name - "options" optionid AUTONUMBER productid NUMBER optionname TEXT sortid NUMBER optionprice NUMBER

Now i want my cfm file to run the following query so that table get created but iam getting database error

CREATE TAB开发者_开发百科LE options
(
    optionid INTEGER AUTOINCREMENT,
    productid INTEGER,
    optionname VARCHAR(255),
    sortid INTEGER,
    optionprice INTEGER
);

---

Did you try following the same rules as when you create the table manually:

CREATE TABLE options
(
    optionid NUMBER AUTONUMBER,
    productid NUMBER,
    optionname TEXT,
    sortid NUMBER,
    optionprice NUMBER 
);