Alison Balter's Mastering Access 2002 Enterprise Development

Understanding the Benefits

In Access 2.0, there were many marginal benefits of added transaction processing because Access 2.0 did no implicit transaction processing itself. Listing 16.1 shows code that, when run in Access 2.0, writes the data to disk each time the Update method occurs in the loop. These disk writes were costly in terms of performance, especially if the tables were not located on a local machine.

Listing 16.1. Transaction Processing Using Access Basic as Seen in Access 2.0

Sub IncreaseQuantity() On Error GoTo IncreaseQuantity_Err Dim db As DATABASE Dim rst As Recordset Set db = CurrentDb Set rst = db.OpenRecordset("Select OrderId, _ Quantity From tblOrderDetails", _ dbOpenDynaset) 'Loop through recordset increasing Quantity ...