Alison Balter's Mastering Access 2002 Enterprise Development

Form-Locking Strategies

Earlier in the chapter, you learned about the locking strategies for forms: No Locks, All Records, and Edited Record. Using the three locking strategies, as appropriate, you can develop a multiuser application with little or no multiuser programming. You won't gain the same power, flexibility, and control that you get out of recordsets, but you can quickly and easily implement multiuser techniques. In this section, you will see how all three of these strategies affect the bound forms in your application.

No Locks

The No Locks option means that Access won't lock the page of data with the edited record until it tries to write the changed data to disk. This happens when there's movement to a different record or the user explicitly ...