run several SQL queries at once

  • Thread starter Thread starter Maileen
  • Start date Start date
M

Maileen

Hi,

I would like to know how can I run several SQL queries at once under MS
Access 2003 ?
thanks,
Maileen
 
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.)
 
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.
 
You could always have multiple copies of Access run.

Do your queries take a long time to execute??
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

run several queries at once 1
View all queries in Sql view at once 1
Running reports in a multiuser VB/Access environment 0
Access parameterised queries upsizing to sql server 2
Query SQL report 4
Form datasource from sql server backend 1
Not able to create new tables/queries in .adp 4
Status Bar Message 4

Back
Top