[thelist] MS Access question

[Tab Alleman]

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 !