Hi,
I have several sql statement(to insert, delete records in different tables) which are run by the docmd.runsql command. Is it possible to implement transaction to all statement?
Like this:
begin tran
docmd.runsql 'insert record to tableA
docmd.runsql 'delete record to tableB
...
end tran
if it is possible to do so, could anyone show me how the code should look like? thx!
I have several sql statement(to insert, delete records in different tables) which are run by the docmd.runsql command. Is it possible to implement transaction to all statement?
Like this:
begin tran
docmd.runsql 'insert record to tableA
docmd.runsql 'delete record to tableB
...
end tran
if it is possible to do so, could anyone show me how the code should look like? thx!