Alison Balter's Mastering Access 2002 Enterprise Development

Using Transaction Processing in a Multiuser Environment

In a multiuser environment, transaction processing has implications beyond the protection of data. By wrapping a process in a transaction loop, you ensure that you Using Transaction Processing in a Multiuser Environment are in control of all records involved in the process. The cost of this additional control is reduced concurrency for the rest of the users of the application. Listing 16.5 illustrates this scenario.

Listing 16.5. A Safe Way to Do Transactions in a Multiuser Environment That Sacrifices Concurrency

Sub MultiPessimistic() On Error GoTo MultiPessimistic_Err Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim intCounter As Integer Dim intChoice As Integer Dim intTry As ...