[thelist] MS Access question

Ryan Carmody carmodyryan at hotmail.com
Thu Apr 12 12:43:23 CDT 2001


>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





More information about the thelist mailing list