I do not have my (VisualBasic) code around me right now, but when looking into MS ACCESS Help: MS Jet SQL has TRANSACTION statement, ADO has RollBackTrans method, DAO has RollBack method.
Now, this is WOT: DAO methods of MS VisualBasic, here?.. ;o)
To make errors is human. But to make million errors per second, you need a computer.