When you're dealing with a multiuser environment, it's worth the effort to come up with a robust way of handling issues. Access is great out of the box on a network, but to get performance enhancements and increased control—whether it's tweaking the option settings, splitting databases, or creating unbound forms—some work has to be done.
Chapter 21, “Securing Your Application,” discusses options for securing your databases, including multiuser issues.
Chapter 25, “Developing SQL Server Projects Using ADPs,” gives information on creating Access applications that work optimally with SQL Server.
Chapter 26, “Startup Checking System Routines Using DAO,” has a whole section devoted to relinking methods for databases using DAO.
Chapter 27, “Startup Checking System Routines Using ADO,” has a whole section devoted to verifying the back-end database using ADO and the ADP.
Chapter 28, “Creating Maintenance Routines,” contains information and examples for replicating tables from back end to front end for performance.
3.15.27.232