Tips for editing Access database objects in a multiuser environment

• It's a good idea to design objects before you allow other users to open the Microsoft Access database for shared access. When you want to make design changes, you can ensure that you're the only one using the Access database when you open it by clicking Open Exclusive on the Open button in the Open dialog box. Learn about saving changes to a shared Microsoft Access database.
  
  
• If another user has a table open or is viewing data in queries, forms, or reports based on the table, you can't make any changes to the table's design. Microsoft Access informs you that it is read-only.
  
  
• If objects are dependent on one another, update all of them at the same time so that other users don't open inconsistent versions of the objects. For example, if you want to add fields to a form, make sure to add the fields to the underlying query before you update the form.
  
  
• If you change a query that another user has open, that user must close and reopen the changed object to use the latest version. With Visual Basic for Applications modules, other users can't run the updated Function or Sub procedures until they close and reopen the Access database.