By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,155 Members | 2,518 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,155 IT Pros & Developers. It's quick & easy.

Access transaction

P: n/a
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.
Dec 19 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

<da************@gmail.comwrote in message
news:76**********************************@t1g2000p ra.googlegroups.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.
Dec 20 '07 #2

P: n/a
On 19 déc, 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
Dec 20 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.