Microsoft KB Archive/214489

= ACC2000: Add-in Manager Does Not Display Custom Menu Add-in =

Article ID: 214489

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q214489



Advanced: Requires expert coding, interoperability, and multiuser skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



SYMPTOMS
After you use the Microsoft Access Add-in Manager to install a custom menu add-in in Microsoft Access 2000, the custom menu add-in is not listed as an installed menu add-in. However, you are able to use the menu add-in successfully.



CAUSE
The file name of the custom menu add-in that you installed does not have either an .mda or .mde extension. The Add-in Manager only displays installed menu add-ins that have a .mda or .mde extension.



RESOLUTION
Change the extension of the menu add-in so that it is either .mda or .mde before you install the menu add-in. If your menu add-in is using a USysRegInfo table, you must also change the extension of the file name of the add-in.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce Behavior
 Start Microsoft Access 2000. Create a new, blank database, and name it MyAddIn.mdb. Create a new, blank form in Design view. Add a command button to the form.  Set the OnClick property of the command button to the following event procedure: Private Sub Command1_Click MsgBox "My AddIn" End Sub </li> Save the form as frmMyAddIn, and then close it.</li>  Insert a new, blank module into the database, and type the following code in the module: Option Compare Database Option Explicit

Function StartMyAddIn DoCmd.OpenForm "frmMyAddIn" End Function </li> Save the module as mdlMyAddIn.</li> On the Tools menu, click Options.</li> Click the View tab.</li> Click to select the Hidden Objects and System Objects check boxes, and then click OK.</li> On the File menu, point to Get External Data, and then click Import.</li> In the Files of Type box, select Microsoft Access.</li> Browse to the 1033 folder of the Microsoft Office installation folder on your computer. By default, this is Program Files\Microsoft Office\Office\1033.</li> Click the Acwzmain.mde file, and then click Import.</li> In the Import Objects dialog box, click the Tables tab.</li> Click the USysRegInfo table, and then click OK.</li> Open the USysRegInfo table in Datasheet view, and delete any records that may be present.</li> Add the following records to the table:

</li> Close the database.</li> <li>Open the sample database Northwind.mdb.</li> <li>On the Tools menu, point to Add-Ins, and then click Add-in Manager.</li> <li>Click Add New.</li> <li>In the Files of Type box, click All Files(*.*).</li> <li>Locate the MyAddIn.mdb file that you created in step 2, and then click Open. Note that MyAddIn is listed as an installed menu add-in.</li> <li>Click Close to close the Add-in Manager.</li> <li>On the Tools menu, point to Add-Ins, and then click MyAddIn. Note that the add-in form that you created in MyAddIn.mdb opens.

</li> <li>Close the form.</li> <li>On the Tools menu, point to Add-ins, and then click Add-in Manager.</li></ol>

Note that the menu add-in is no longer listed as being installed.

How to Uninstall Add-ins Not Listed in the Add-in Manager
To uninstall a menu add-in that is not listed in the Add-in Manager, follow these steps.

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

<ol> <li>Quit Microsoft Access.</li> <li>Start Registry Editor.</li> <li> Browse to the following key in the Windows registry: <pre class="fixed_text">  HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0\Access\Menu Add-Ins </li> <li>Under the Menu Add-Ins key, locate the key that represents your menu add-in, and select it.</li> <li>On the Edit menu, click Delete. When prompted to confirm the deletion of the key, click Yes.</li> <li>Quit Registry Editor.</li> <li>Start Microsoft Access.</li> <li>Open the sample database Northwind.mdb.</li> <li>On the Tools menu, point to Add-ins.</li></ol>

Note that the custom menu add-in is no longer listed on the Add-ins submenu.

<div class="references_section">