whats wrong with this sql statement?

Hi what is wrong with this sql statement?

VB Code:

mySQLstring = "CREATE TABLE Reservations2002 ResNumber LONG CONSTRAINT myconstraint PRIMARY KEY, CustomerID LONG, ReservationDate DATETIME, FreeDay LONG, Status TEXT (50) );"
    mydb.Execute mySQLstring

The above code generates the following error....

"Sytax error in CREATE TABLE statement"

is this too obvious??

you have no bracket after the table name...

Warning to other programmers. Do not go to work on 4 hours sleep or you start to go blind!!!!

I'm an idiot!