Create Table [MyHome](ID AUTOINCREMENT CONSTRAINT pk1 PRIMARY KEY, UserID Integer, ModuleID Integer CONSTRAINT F_KEY REFERENCES module, SortVal Integer, Pos Integer,) ;

Gives me this:


Microsoft JET Database Engineerror '80040e14'Syntax error in CONSTRAINT clause.

I have tried

Create Table [MyHome](ID AUTOINCREMENT CONSTRAINT pk1 PRIMARY KEY, UserID Integer, ModuleID Integer CONSTRAINT F_KEY REFERENCES module (ID), SortVal Integer, Pos Integer,) ;

no joy there either.

I'm useing an Access 2k DB via ASP in case that makes blind bit of difference.

opps there seems to be a bonus comma!!!