Transactions?

[BobRoyAce]

Let's say that I have a series of update queries I'd like to run in a
procedure all going against different tables. In the VB world (outside of
Access) I could use Transactions by using BeginTrans, CommitTrans,
RollbackTrans methods of a connection object. Is there a way to do this in
Access 2000 VBA?

 

[Allen Browne]

Sure.

There is an example of using transactions in Access, and discussion of the
pitfalls in article:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html