Creating a table with multiple key and boolean fields in SQL

I'm having problems using DDL SQL commands via ADO onto an Access mdb file.
Can someone point me at a reference source for the supported syntax etc.?

Or specifically tell me how to create a table with multiple field primary
key and integer (not longint) and boolean fields.

It is something like
CREATE TABLE MyTable (Field1 INTEGER, Field2 INTEGER, .... FieldX BOOLEAN)

but "Boolean" is wrong and Integer gives me LongInt fields.
Then followed by
ALTER TABLE MyTable
ADD CONSTRAINT PK_code PRIMARY KEY (field1, field2)
to add the primary key, or can I do it in the create statement somehow?

Thanks
Dave


.