Multple Queries

  • Thread starter Thread starter Taf
  • Start date Start date
T

Taf

I'm trying to run a Delete statement and two seperate
Insert statements in one query. Is there a particular
keyword or punctuation that I should be putting in the
query? In short, my question is How do I execute
multiple queries in Access with only 1 call to the
database?
 
Access cannot execute multiple action queries in one statement.

However, it is possible to wrap several query statements in a transaction,
so as to get an all-or-nothing result. Details in this article:
http://allenbrowne.com/ser-37.html
 
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

How do I execute multiple SQL statements in Access?? 3
Calling Parameterized Query Using SQL Syntax 3
Union query 5
Queries 2007 vs 2003 7
Criteria of parameter queries 2
Counting multiple memberships 1
Query for Export 1
"is not a valid name. Make sure 7

Back
Top