• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 17. Manipulating Data with ADO > Using Transactions to Commit Groups of...

Using Transactions to Commit Groups of Records—or Not

Access doesn’t support transaction processing directly. However, ADO’s Connection object does, so you can benefit from transaction processing even though Access doesn’t directly support the process.

Transaction processing involves treating multiple updates to multiple records as one process instead of several. If one update fails, they all fail. If one update is made, they’re all made. This type of control is important to business processes where changing one value can have far-reaching results. For instance, let’s suppose you commit an order, update the inventory numbers, and update an accounting application for billing purposes, accordingly. Now, what happens if the customer calls to cancel part or even all of the order? Not only must you clear the order from the customer’s account, you must also return the items to the inventory. If you do one without the other, the balance sheet will be off somewhere and it might take a long time to find the error.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint