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

17-August-2021
In relational database management systems (RDBMS), there is often a need to have groups of SQL statements executed together. This can happen for many reasons. When you use transactions, you can back out of many statements, even if prior statements in the transaction were successful. This is very handy when you want ALL or NONE of your statements to be successful. You can also back out of a bunch of statements if the error is a SQL error or a VBA error. Add transactions to your toolkit!



SQL Project? Contact me today!