Commit Rollback - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Commit Rollback

Edward Mastoloni

3 years ago

Is there a lesson that discusses how to use commit and rollback when processing a transaction that writes to another table? For instance, if I am posting a sales order, I have code that writes to a posted invoice table as well as builds customer ledger entries and other GL entries. I want the DB to rollback any changes if the process doesn't fully complete for whatever reason. Is that possible?

	Adam Schwanz @Reply 3 years ago
You could just use unbound fields for data entry, then make a button with SQL statements or CurrentDb.Execute Insert/Update statements that fill the records if they complete everything.

	Alex Hedley @Reply 3 years ago
`DBEngine.BeginTrans CurrentDb.Execute "" DBEngine.CommitTrans` If error `DBEngine.Rollback`

	Edward Mastoloni OP @Reply 3 years ago
Alex is there a video that discusses/explains BeginTrans. CommitTrans & Rollback?

	Alex Hedley @Reply 3 years ago
I can't remember is the Access SQL Seminars, Richard?

	Richard Rost @Reply 3 years ago
I have not covered that yet but it is on the list.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View