Beginning Access™ 2007 VBA

A.12. Chapter 12

1. One way to improve support for multiple users is to ensure that the proper type of record locking is being used. If your application is using page or table locks, for example, then more records than the one being accessed will be locked and other users will be unable to modify them. With bound forms, you can modify table locks in Tools Options on the Advanced tab. With unbound forms, you specify the lock type in your code, for example by setting the lock type of your ADO recordset. Another way to improve support for multiple users is to separate standalone Access databases into two separate files: one database file that contains the tables and is shared on a network and another database file with the user-interface objects that is loaded onto each user's computer.

2. There are various ways to improve the performance of your Access applications. One way is to optimize the queries that retrieve data to ensure that they use the correct syntax, join to the correct tables, and use indexes so the retrieval will be faster. Another way to improve performance is to reduce the complexity of your forms, for instance by eliminating unnecessary controls and moving some code from forms to standard modules. Improving the code itself is another way to improve performance. For example, make sure to use the smallest data type you really need, make your procedures reusable to eliminate ...