go into access and go to queries, and do create query, and then "SQL view" and enter the SQL directly into the window, and then run it. -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Ryan Carmody Sent: Thursday, April 12, 2001 1:44 PM To: thelist at lists.evolt.org Subject: Re: [thelist] MS Access question >outta curiosity, didja open Access and run that SQL statement? I don't know where to run it in access...that's what I'm asking. >and do you need to do this via scripting from a web app? or are >you trying to re-use some SQL statements? I'm actually just testing the statements locally before I run them on an SQL server. >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? _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com --------------------------------------- For unsubscribe and other options, including the Tip Harvester and archive of TheList go to: http://lists.evolt.org Workers of the Web, evolt !