Ways to optimize multiuser performance in an Access database

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 .
  
  
• Choose an appropriate record-locking strategy. For more information, click .
  
  
• Choose a locking level strategy.
  
  
• 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 .
  
  
• Optimize table performance. For more information, click .
  
  
• Improve the performance of Access databases with linked tables. For more information, click .
  
  
• Improve the performance of Access tables linked to an SQL table. For more information, click .
  
  
• Convert the workgroup information file. For more information, click .