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

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 saves the data in the record. If page locking is in place, the No Locks option is the least restrictive locking option for forms.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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