Microsoft KB Archive/135375

= ACC2: How to Use Custom Toolbars from Other Databases =

Article ID: 135375

Article Last Modified on 11/6/2000

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q135375



SUMMARY
This article describes a method that you can use to import custom toolbars from one database into another database. The method uses the MSysToolbars system table that stores the definitions for custom toolbars.

NOTE: Although manipulating system tables is neither supported nor encouraged, the only method for using previously defined toolbars is to transfer the relevant system table from one database to another.



MORE INFORMATION
Before importing custom toolbars into a database, you must determine if a MSysToolbars system table exists in the target database (the database to which you want to add the toolbars).

To determine if the MSysToolbars table exists, follow these steps:


 * 1) Open the target database.
 * 2) On the View menu, click Options.
 * 3) In the Options dialog box, set Show System Objects to Yes, and then click the OK button.
 * 4) In the Database window, click the Tables tab and determine if the MSysToolbars table exists.

NOTE: If MSysToolbars table does not exist, use Method 1 to import the toolbars. If MSysToolbars table does exist, use Method 2.

Method 1: No MSysToolbars Table in Target Database

 * 1) Open the target database.
 * 2) On the File menu, click Import.
 * 3) In the Import dialog box, under Data Source, select Microsoft Access, and then click OK.
 * 4) In the File Name box, select the database that contains the custom toolbars that you want to import, and then click OK.
 * 5) In the Object Type box, select Tables. In the Objects In  box, select MSysToolbars, and then click the Import button. Click OK when you are notified that the table was successfully imported.
 * 6) Close the Import Objects window.
 * 7) Close the target database and reopen it. Note that you can gain access to the newly transferred custom toolbars using the Toolbars command on the View menu.

Method 2: MSysToolbars Exists in Target Database

 * 1) Open the database that contains the toolbars that you want to transfer to the target database.
 * 2) In the Database window, select the MSysToolbars table.
 * 3) On the Edit menu, click Copy.
 * 4) Close the current database.
 * 5) Open the target database.
 * 6) On the Edit menu, click Paste.
 * 7) In the Paste Table As box, type MSysToolbars as the table name, click the "Append Data to Existing Table" option button, and then click OK.
 * 8) Close the target database and reopen it. Note that you can gain access to the newly transferred custom toolbars using the Toolbars command on the View menu.

