Multple Queries

[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?

 

[Allen Browne]

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