F. Scott Barker’s Microsoft Access 2002 Power Programming

Chapter 21. Handling Multiuser Situations

IN THIS CHAPTER

• Understanding Multiuser Terminology 652

• Understanding Multiuser Handling in Access 653

• One or Two Database Containers: Knowing Where to Put the Pieces 657

• Looking at the Built-In Locking Modes 661

• Working in VBA with Unbound Forms 666

• Coding for Multiuser Error Handling 685

You can take Microsoft Access out of the shrink-wrap, place it on a file server, and use it in a multiuser environment with very little programming. However, a more efficient and robust application requires more work.

Placing a single Access database that uses standard bound forms and programming on a network isn’t really recommended. Performance can decrease, and users can become frustrated due to locking conflicts. A little ...