Alison Balter's Mastering Access 2002 Enterprise Development

Using Unbound Forms

One solution to locking conflicts is to use unbound forms. By doing this, you can greatly limit the amount of time a record is locked and fully control when Access tries to secure the lock. Unbound forms require significantly more coding than bound forms, so you should make sure that the benefits you get from using unbound forms outweigh the coding and maintenance involved. With improvements to both forms and the Jet Engine in Access 2000, the reasons to use unbound forms with Access data are less compelling. Unbound forms are covered in more detail in Chapter 13, “Building Unbound Applications.”