run several SQL queries at once

M

Maileen

Hi,

I would like to know how can I run several SQL queries at once under MS
Access 2003 ?
thanks,
Maileen
 
6

'69 Camaro

Hi, Maileen.

If you are referring to running one SQL statement after another in a
sequence, this is not possible in Access. Jet can only parse and execute
one SQL statement at a time.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
A

Albert D. Kallal

Maileen said:
Hi,

I would like to know how can I run several SQL queries at once under MS
Access 2003 ?
thanks,
Maileen
Click to expand...

You can't put multiple queries into a single query that you build.

however, you can certainly create a macro, or a small bit of VB code that
runs a bunch of quires and sql statements one after another.
 
G

Guest

You could always have multiple copies of Access run.

Do your queries take a long time to execute??
 
Top