sql - DoCmd.RunSQL Use Transaction equivalent in adodb.command -

sql - DoCmd.RunSQL Use Transaction equivalent in adodb.command -

in ms access application execute sql code in 2 different ways. first - docmd.runsql sec - adodb.command + executing after.

in first method can set utilize transaction parameter false. there way set adodb.command executing sql code not utilize tranactions? can docmd.runsql, setting parameter?

adodb.command doesn't utilize transaction unless explicitly start 1 in code yourconnection.begintrans. see http://msdn.microsoft.com/en-us/library/windows/desktop/ms680895%28v=vs.85%29.aspx

in short, connection object controls transactions, not commmand object.

sql tsql ms-access adodb