Microsoft KB Archive/201246

= ACC2000: Toolbar Changes May Not Be Saved with Multi-Users =

Article ID: 201246

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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



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.
 * 1) In the first instance, on the Tools menu, click Customize.

Note that you receive the message mentioned in the "Symptoms" section.
 * 1) Click OK.
 * 2) Click the Toolbars tab. Click New. In the New Toolbar dialog box, keep the default name, and then click OK.
 * 3) Add any button to the custom toolbar by clicking the Commands tab and dragging any button to the custom toolbar.
 * 4) Click the Close button in the Customize dialog box.
 * 5) Close the first instance of Microsoft Access. Note that there is no alert indicating that the changes cannot be saved.
 * 6) Close the second instance of Microsoft Access.
 * 7) Re-open the Northwind sample database. Note that the design changes that you made to the toolbar are lost.

Additional query words: cmdbar prb

Keywords: kbprb kbfaq KB201246

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.