I am trying to use the following SQL statement to create a table. All fields are fine, except for the BOOLEAN type. Everytime I try to add these fields I get an error. I must be defining the boolean field incorrectly, but I can't find any "correct" examples.
Any help would be apprecriated.
sqlString = "CREATE TABLE modCBX "
sqlString = sqlString & "(SLIC TEXT(5), DEL_DATE DATETIME, INFO TEXT(24), OVERSIZED BOOLEAN, IRREG BOOLEAN );"
Set cnn = CurrentProject.Connection
cnn.Execute sqlString
Any help would be apprecriated.
sqlString = "CREATE TABLE modCBX "
sqlString = sqlString & "(SLIC TEXT(5), DEL_DATE DATETIME, INFO TEXT(24), OVERSIZED BOOLEAN, IRREG BOOLEAN );"
Set cnn = CurrentProject.Connection
cnn.Execute sqlString