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

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.

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.

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.

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

1. Start Microsoft Access 2000.
2. Create a new, blank database, and name it MyAddIn.mdb.
3. Create a new, blank form in Design view.
4. Add a command button to the form.
5. Set the OnClick property of the command button to the following event procedure:

   Private Sub Command1_Click()
      MsgBox "My AddIn"
   End Sub
   					

6. Save the form as frmMyAddIn, and then close it.
7. 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
   					

8. Save the module as mdlMyAddIn.
9. On the Tools menu, click Options.
10. Click the View tab.
11. Click to select the Hidden Objects and System Objects check boxes, and then click OK.
12. On the File menu, point to Get External Data, and then click Import.
13. In the Files of Type box, select Microsoft Access.
14. Browse to the 1033 folder of the Microsoft Office installation folder on your computer. By default, this is Program Files\Microsoft Office\Office\1033.
15. Click the Acwzmain.mde file, and then click Import.
16. In the Import Objects dialog box, click the Tables tab.
17. Click the USysRegInfo table, and then click OK.
18. Open the USysRegInfo table in Datasheet view, and delete any records that may be present.
19. Add the following records to the table:
    
    

    Subkey	Type	ValName	Value
    HKEY_CURRENT_ACCESS_PROFILE\Menu Add-Ins\&MyAddIn	0
    HKEY_CURRENT_ACCESS_PROFILE\Menu Add-Ins\&MyAddIn	1	Library	|ACCDIR\MyAddin.MDB
    HKEY_CURRENT_ACCESS_PROFILE\Menu Add-Ins\&MyAddIn	1	Expression	=StartMyAddIn()

20. Close the database.
21. Open the sample database Northwind.mdb.
22. On the Tools menu, point to Add-Ins, and then click Add-in Manager.
23. Click Add New.
24. In the Files of Type box, click All Files(*.*).
25. 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.
26. Click Close to close the Add-in Manager.
27. 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.
    
    
28. Close the form.
29. On the Tools menu, point to Add-ins, and then click Add-in Manager.

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.

1. Quit Microsoft Access.
2. Start Registry Editor.
3. Browse to the following key in the Windows registry:

      HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0\Access\Menu Add-Ins
   					

4. Under the Menu Add-Ins key, locate the key that represents your menu add-in, and select it.
5. On the Edit menu, click Delete. When prompted to confirm the deletion of the key, click Yes.
6. Quit Registry Editor.
7. Start Microsoft Access.
8. Open the sample database Northwind.mdb.
9. On the Tools menu, point to Add-ins.

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

For additional information about add-ins not being displayed in Microsoft Access Project (ADP) files, click the article number below to view the article in the Microsoft Knowledge Base: For additional information about creating custom add-ins in Microsoft Access 2000, click the article number below to view the article in the Microsoft Knowledge Base: