O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required