Access VBA, SQL and doing Transactions

[oioioi]

Trying to do multiple inserts with a transaction and rollback, but I haven't found a way to do it using DoCmd.runSQL().

It does not seem like runSQL supports "BEGIN TRANSACTION"...

Sample code is always nice...