Hello everybody
I'm trying to find how to know if there is a current transaction
(after using DBEngine.BeginTrans).
Is there a property or function that indicates me that????
Thanks.
No. AFAIK, DAO does not expose that information to you.
Part of the issue here is that it's not merely a yes/no question. DAO
permits the nesting of transactions to 5 levels.
What most of us do is to set our own flags to indicate whether a transaction
is present or not, and also to use error handling to recover in case the
transaction does not exist.
There's an example here:
Archive: Move Records to Another Table
at:
http://allenbrowne.com/ser-37.html
with explanation and discussion of the traps when using transactions. In the
example, the boolean variable bInTrans indicates if a transaction is
present.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
news:76f23170-161d-4ff5-91d4-5533e6c9aa21@t1g2000pra.googleg roups.com...
> Hello everybody
>
> I'm trying to find how to know if there is a current transaction
> (after using DBEngine.BeginTrans).
> Is there a property or function that indicates me that????
>
> Thanks.
On 19 d=E9c, 13:51, darwinbaldr...@gmail.com wrote:
> Hello everybody
>
> I'm trying to find how to know if there is a current transaction
> (after using DBEngine.BeginTrans).
> Is there a property or function that indicates me that????
>
> Thanks.
Ok. I'll implement the counter.
Thanks