ACC2000: Toolbar Changes May Not Be Saved with Multi-Users (201246)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q201246
Advanced: Requires expert coding, interoperability, and multiuser skills.

SYMPTOMS

When multiple users use a Microsoft Access database, changes they make to a custom toolbar (not a built-in toolbar) may not be saved when the database is closed.

If you are one of the multiple users in a database, and you begin editing a custom toolbar, you may receive the following message:
You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later.
At this point, you are allowed to make the changes and to close the Customize dialog box. Later, when you close the database, Microsoft Access tries to save the toolbar changes, but if it cannot get an exclusive lock when the database closes, the changes are lost without warning.

CAUSE

Microsoft Access cannot save changes to a custom toolbar if you do not have an exclusive lock on the database. An exclusive lock means that there are no other open instances of the database.

For more information about this issue, please see the following article in the Microsoft Knowledge Base:

200290 ACC2000: Need Exclusive Lock to Save Design Changes to Objects

MORE INFORMATION

Steps to Reproduce Behavior

  1. Click Start, point to Programs, and then click Microsoft Access.
  2. When the Create a new database using dialog box opens, click Northwind, and then click OK.
  3. Again click Start, point to Programs, and click Microsoft Access.
  4. Again, when the Create a new database using dialog box opens, click Northwind, and then click OK.

    You now have two instances of Microsoft Access open, and each instance is using the sample database Northwind.mdb.
  5. In the first instance, on the Tools menu, click Customize.

    Note that you receive the message mentioned in the "Symptoms" section.
  6. Click OK.
  7. Click the Toolbars tab. Click New. In the New Toolbar dialog box, keep the default name, and then click OK.
  8. Add any button to the custom toolbar by clicking the Commands tab and dragging any button to the custom toolbar.
  9. Click the Close button in the Customize dialog box.
  10. Close the first instance of Microsoft Access. Note that there is no alert indicating that the changes cannot be saved.
  11. Close the second instance of Microsoft Access.
  12. Re-open the Northwind sample database. Note that the design changes that you made to the toolbar are lost.
Modification Type:MajorLast Reviewed:6/28/2004
Keywords:kbprb KB201246
©2004 Microsoft Corporation. All rights reserved.