[DJMaze]

in mysql/postgresql:

query: BEGIN;
your queries here
query: COMMIT;
on failure:
query: ROLLBACK;

in ms sql:

query: BEGIN TRANSACTION;
your queries here
query: COMMIT;
on failure:
query: ROLLBACK;

I don't know the exact command for ODBC/Access though