[thelist] MS Access question
Tab Alleman
talleman at autobex.com
Thu Apr 12 14:08:58 CDT 2001
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 !
More information about the thelist
mailing list