Full Version: Transactions in VBA
UtterAccess Forums > Microsoft® Access > Access Forms
AC2Designs
I searched for Transactions and Access Transactions and SQL Transactions but was unable to find anything
to help me out...
The tables I am updating are all via VBA code, and I use DAO. How do I setup Transactions, and then Commit or Rollback.???
I guess I just put the Rollback in my Error Handler section???? and the Commit in the Line just above my
Error Handler???
I appreciate the help.
Kevin
Aquadevel
Here's a link to Transactions in the archives
Good luck,
HiTechCoach
Are you referring to you previous post

I did you try searching on my suggestions in your previous post? You should have found these in the Access help files and on the web.

Normally you want to reply back to the original thread so that all the information related to the topic is together. I have been looking for you response to your previous post when I just stumbled across this new one.

Please look at your original post for some code samples.

Hopefully the code the will help you ...


Edited by: HiTechCoach on Wed Aug 15 13:38:05 EDT 2007.
GlenKruger
See Attached
had these old notes kicking around hopefully they will point you in the right direction.
AC2Designs
Coach:
Odid not see your 2nd post or the edits you made to the first response, until now. I've had several instances
where my follow up questions were never addressed, so I created a new post. I'll be a bit more patient in the
future....
Thanks for the examples by the way. I'm still a little confused...(I have downloaded but not looked at Glenn's attachment
yet)...
Let me test a few things and get back to you.
Thanks for your help.
Kevin
HiTechCoach
Kevin,
ransactions are confusing at first. I have found them very useful in Accounting and payroll systems.
We will be here if you have any more questions.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.