Ways to optimize multiuser performance in an Access database
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
The following guidelines can help you optimize the performance of Microsoft Access databases that are used in a multiuser environment.
Put only the tables on a network server, and keep other database objects on users' computers. The database's performance will be faster because only data is sent across the network. You can separate the tables from other database objects by using the Database Splitter Wizard. For more information, click aa219035(v=office.10).md.
Choose an appropriate record-locking strategy. For more information, click aa190352(v=office.10).md.
Avoid locking conflicts by adjusting Refresh Interval, Update Retry Interval, Number Of Update Retries, and ODBC Refresh Interval settings (if applicable). For more information, click aa156264(v=office.10).md.
Optimize table performance. For more information, click aa170290(v=office.10).md.
Improve the performance of Access databases with linked tables. For more information, click aa170262(v=office.10).md.
Improve the performance of Access tables linked to an SQL table. For more information, click aa170292(v=office.10).md.
Convert the workgroup information file. For more information, click aa831032(v=office.10).md.