Multiple SQL statements in one query?

[muneco]

Hi,

I am creating a series of Access 2000 queries to create and populate a database. I was wondering if it is possible to put multiple SQL statements in one query.

For example, can I say something like

create table table1 (fld1 autoincrement primary key, fld2 text);
insert into table1 (fld2) values ("widgets"


Or do I need to create two separate queries, one for each statement? Your help and expertise will be appreciated.

 

[JeremyNYC]

Only one statement per query. You can, however, check out the Execute method of the docmd object, which you could use in code to do as many different things as you want.

Jeremy ==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[muneco]

Thanks Jeremy, I appreciate your reply.

Best wishes.