Hi all,
I'm trying to create a new table in access using an SQL statemtent from within ASP.
The generated statement is


CREATE TABLE test (text1 char(255),date1 date,text2 char(20),text3 char(20), text4 bit)

I keep getting syntax error. When i remove the last variable and it's


CREATE TABLE test (text1 char(255),date1 date,text2 char(20),text3 char(20))

the table is created and there are no errors.
I'm trying to create a yes/no field. Is bit the correct datatype or is there another datatype i should use?
Thanks in anticipation