NO. BUt, you can define a transaction with the connection object and submit
the commands separately.

----- Original Message -----
From: "Alstom" <Alstom@v...>
To: "professional vb" <pro_vb@p...>
Sent: Friday, November 22, 2002 5:30 AM
Subject: [pro_vb] Multiple SQL statements


> Can anyone tell me if it is possible to execute multiple SQL queries with
> Access?
> And if it is possible, How to terminate each statement (I use a ";" int
the
> example that follows, as I would do in Oracle)
>
> I want to send a string like this to the Access database dbMyLife:
>
> strSQL = "DELETE FROM MyMind WHERE Time = 'LastNight';" _
> &      & "UPDATE MyOutTray SET WorkDone = True;"
>
> (Forgetting for a moment that Access is not transactional, which means
that
> I won't be able to "Reverse" everything when something goes wrong.)
>
> Kind Regards,
> Brad.
>
>
>
>
>
>
> DISCLAIMER : Volkswagen of South Africa (Pty) Ltd
>
> Any views expressed in this message are those of the individual sender.
> No liability shall attach whatsoever to VWSA from this communication
except
> where the sender is acting on specific authority of VWSA, such authority
> being public record and acknowledged by VWSA by nature of the employee's
> functions. This document may in no way be photocopied, printed, scanned or
> electronically duplicated for any purposes other than that for which it
was originally
> intended.
>
> If you are not the intended recipient of this communication, please
discard
> this message and notify VWSA immediately at postmaster@v...
>