ACC2000: Add-in Manager Does Not Display Custom Menu Add-in (214489)


The information in this article applies to:

  • Microsoft Access 2000
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.

MORE INFORMATION

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:

    SubkeyTypeValNameValue
    HKEY_CURRENT_ACCESS_PROFILE\Menu Add-Ins\&MyAddIn0
    HKEY_CURRENT_ACCESS_PROFILE\Menu Add-Ins\&MyAddIn1Library|ACCDIR\MyAddin.MDB
    HKEY_CURRENT_ACCESS_PROFILE\Menu Add-Ins\&MyAddIn1Expression=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.

REFERENCES

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:

199316 ACC2000: Converted Add-In Not Displayed in Access Project

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:

201735 ACC2000: How to Create USysRegInfo Table for Installing Add-ins

Modification Type:MinorLast Reviewed:7/14/2004
Keywords:kbbug kbpending KB214489
©2004 Microsoft Corporation. All rights reserved.