ACC2: How to Use Custom Toolbars from Other Databases

ID: Q135375

The information in this article applies to:

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 <Database> 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.



REFERENCES

For more information about creating or using custom toolbars, search for "toolbars," and then "Custom Toolbars" using the Microsoft Access Help menu. 


Keywords          : kbui UifToolb 
Version           : 2.0
Platform          : WINDOWS 
Issue type        : kbhowto

Last Reviewed: May 3, 1999