outta curiosity, didja open Access and run that SQL statement? and do you need to do this via scripting from a web app? or are you trying to re-use some SQL statements? > From: "Ryan Carmody" <carmodyryan at hotmail.com> > > Does anyone know if it's possible to create a table in MS Access using > SQL like CREATE TABLE [dbo].[calendar_category] ( > [calendar_category_ID] [int] IDENTITY (1, 1) NOT NULL , > [agent_ID] [int] NULL , > [calendar_category_descr] [varchar] (20) NULL > ) ON [PRIMARY] > GO > ? > If so how?