How to use Transactions in MS Access - BeginTrans, Commit, Rollback

[@theycallmerye3]

"Set dB = CurrentDb" is not working on mine... The code runs fine until that point, at which it exits (skipping the error because blnInProcess is still false at this point). Help.

[@seanmackenziedataengineering]

On some systems you may need to use Dim db as DAO.Database
Try that and let me know!

[@theycallmerye3]

@@seanmackenziedataengineering Thanks for the tip!👍 I'll definitely let you know when I get around to trying it.

[@mohammedfarhat1444]

thank you for your great video, it is so clear and so easy, thank you very much

[@seanmackenziedataengineering]

Thanks for the feedback! Glad it worked for you.

[@An-be5bh]

Thank you, this was very helpful!

[@seanmackenziedataengineering]

Good to hear!

[@imstevemcqueen]

Can you use action queries in the transaction, or do you have to use SQL statement? I have two tables with 64 fields in each and trying to avoid the typing

[@seanmackenziedataengineering]

Great question! You can use all of the types, insert, update, delete, etc.

[@imstevemcqueen]

@@seanmackenziedataengineering Thank You !!

[@rogerio74c]

Hi Sean! I´ve used your method for transaction and that worked just fine for inserts. But I am trying to do the same for updates and it just doesnt work. It´s strange, the first time it work, but the second time or the next ones it just dont update the values, and I dont know why. The database become locked too, so I have to close everything so that things come back to normal state.

[@rogerio74c]

I see now that even if I try to exclude or update the item directly in the table, I cant do it. The records become locked. Wierd... Do you have any idea of why does it happen? Thank you

[@seanmackenziedataengineering]

Interesting.. can you post or send your code?

[@RH-hc7th]

thanks for sharing.

[@seanmackenziedataengineering]

You bet!

[@abdullahazrezar8005]

👍

[@seanmackenziedataengineering]

Thanks!

[@SAMYTAHER]

👍

[@seanmackenziedataengineering]

Thx!