CREATE TABLE syntax error...

CREATE TABLE Agents
(ID COUNTER NOT NULL CONSTRAINT constraintName_pk PRIMARY KEY,
Name VARCHAR(255),
Supervisor INTEGER,
MasterCalendarVisible BOOLEAN default false)


I'm using this against an Access DB using JET driver... I keep getting
a syntax error which goes away when I remove the last line... Any
ideas whats wrong with it?


Thanks!

Re: CREATE TABLE syntax error...

NEVERMIND!

Im an idiot... Just needed to swap BOOLEAN for BIT...