How to set USE TRANSACTION property in ADO to execute a query?

[surotkin]

Hi everybody,
I have an action (update) query that gives me error

There isn't enough disk space or memory to undo the data changes this action query is about to make.

I found that if I change property USE TRANSACTION to NO in MS Access interface (Database Window), then the error disappears.
However, when I try to execute the same action query in ADO using COMMAND object, then ADO doesn't execute the query (RecordsAffected returns zero).

Does anybody know how to set USE TRANSACTION property in ADO to execute a query?

Thanks.
surotkin