ACC2000: Converted Add-In Not Displayed in Access Project

ID: Q199316


The information in this article applies to:

Moderate: Requires basic macro, coding, and interoperability skills.

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


SYMPTOMS

If you use a converted Microsoft Access 97 add-in in Access 2000, the add-in appears on the Add-Ins menu of an Access database (.MDB ), but not in an Access project (.ADP).


CAUSE

In Access 97, each add-in contains a table called USysRegInfo. USysRegInfo contains three entries (rows) that allow the add-in to be installed and that determine its behavior.

Access 2000 uses a fourth entry (row) in the USysRegInfo table to determine whether the add-in should be visible in a Microsoft Access database, in a Microsoft Access project, or in both. If the fourth entry is missing, the add-in will be visible only in an Access database.


RESOLUTION

To modify a converted Access 97 add-in so that it can be used in an Access project, follow these steps:

  1. On the File menu, click Open Database.


  2. In the Files of Type box, select Add-Ins.


  3. Find and open the add-in that you want to modify.


  4. On the Tools menu, click Options.


  5. On the View tab of the Options dialog box, select the System Objects option so that you can view system objects.


  6. Open the USysRegInfo table.


  7. Add a fourth row to the USysRegInfo table. Fill the collumns with the following information:



  8. Value Usage
    1 Show this Add-In in Microsoft Access databases (.MDB) only (default)
    2 Show this Add-In in Access Projects (.ADP) only.
    3 Show this Add-In in both Microsoft Access Database and Microsoft Access Projects.

  9. On the Tools menu, point to Add-Ins, and then click Add-In Manager.


  10. Find the old version of your add-in in the Available Add-Ins list, select it, and click Uninstall.


  11. Close the Add-In Manager, and then close Access.

    NOTE: When you install an add-in, a copy of the add-in file (.MDA) is copied to a location specified in the USysRegInfo table and is used by Microsoft Access in the future. Before you can install the revised version of your add-in, you must find and rename or delete the earlier version that was copied. You can find all instances of the add-in by clicking Start, pointing to Find, and then clicking Files or Folders. Search for and rename all instances of the add-in file except for the .MDA file you have just modified.


  12. Open any Access database or Access project, and re-install the modified add-in.



MORE INFORMATION

Steps To Reproduce Behavior

  1. In Access 7.0 or Access 97, create an add-in.

    NOTE: For details on creating add-ins, see the References section of this article.


  2. Open the add-in in Access 2000 and when prompted, click the option to convert it.


  3. On the Tools menu, click Options.


  4. On the View tab of the Options dialog box, select the System Objects option so that you can view system objects.


  5. Open the USysRegInfo table. Note there are only three rows in the table.


  6. Close the add-in and open the sample project, NorthwindCS.adp.


  7. On the Tools menu, point to Add-Ins, and then click Add-In Manager.


  8. In Add-In Manager, click Add New. Locate and install the recently converted add-in.


  9. Close the Add-In Manager.


  10. On the Tools menu, click Add-Ins. Note that the add-in that you just installed does not appear.


  11. Close NorthwindCS.adp, and open the sample database Northwind.mdb.


  12. On the Tools menu, point to Add-Ins and note that the add-in does appear in the Add-Ins list.



REFERENCES

For more information, see Chapter 11, "Add-ins, Wizards, Libraries and Templates," in The Microsoft Office 2000/Visual Basic Programmer's Guide.

To order the Office Programmer's Guide (ISBN: 1-57231-952-6) directly, call (800) MSPRESS in the United States or (800) 667-1115 in Canada. Or visit http://mspress.microsoft.com/.

Additional query words: prb


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

Last Reviewed: June 16, 1999