ACC2000: Add-in Manager Doesn't Display Custom Menu Add-in

ID: Q214489

The information in this article applies to:
  • Microsoft Access 2000
Advanced: Requires expert coding, interoperability, and multiuser skills.

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

IMPORTANT: This article contains information about editing the registry. Before you edit the registry, make sure you understand how to restore it if a problem occurs. For information about how to do this, view the "Restoring the Registry" Help topic in Regedit.exe or the "Restoring a Registry Key" Help topic in Regedt32.exe.

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 this to be a problem in the Microsoft products 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:


    6. 
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:


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


    28. 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: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the "Changing Keys and Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete Information in the Registry" and "Edit Registry Data" Help topics in Regedt32.exe. Note that you should back up the registry before you edit it. If you are running Windows NT, you should also update your Emergency Repair Disk (ERD).
  1. Quit Microsoft Access.


  2. Start Registry Editor.


  3. Browse to the following key in the Windows registry:


    4. 
   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:

Q199316 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:
Q201735 ACC2000: How to Create USysRegInfo Table for Installing Add-ins

Additional query words: addin add in deinstall

Keywords : kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: January 5, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.