ACC2: How to Use Custom Toolbars from Other Databases

MORE INFORMATION

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.

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.