Error message 3003 couldn't start transaction, to many transaction

[jokobe]

When trying to start a transaction with begin.trans and db.execute in Acc
2000 I always receive the error message:
"Couldn't start transaction, too many transaction open"
(this is translated from german).

any helpful hint?

thanks in advance

jokobe

 

[Allen Browne]

Access suppports up to 5 levels of nested transactions.

When you are testing/debugging your code, it is very common to BeginTrans
and exit the code without a CommitTrans/Rollback. The result is that you are
still operating in a transaction without realizing it.

The solution is to RollBack repeatedly until you are no longer in a
transaction. Assuming you opened the transaction on the default workspace,
open the Immediate Window (Ctrl+G) and enter:
dbEngine(0)(0).RollBack
repeatedly until you get error 3034.

This issue is trap #4 in this article:
http://allenbrowne.com/ser-25.html
You may be interested in the others as well.

 

[jokobe]

There is no command dbEngine(0)(0).RollBack with Acc 2000. Returns
error message:
"Error while compiling: Function or interface can only be used restricted or
VB isn't supporting this type of automation".

jokobe

 

[jokobe]

The command is working with:
dbEngine(0).RollBack


Thanks for your fast help

Jokobe

 

[Allen Browne]

Yes: you're right.
Glad you got it solved.