Microsoft KB Archive/199316

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

Article ID: 199316

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q199316



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

This article applies to a Microsoft Access database (.mdb) and to 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:  On the File menu, click Open Database. In the Files of Type box, select Add-Ins. Find and open the add-in that you want to modify. On the Tools menu, click Options. On the View tab of the Options dialog box, select the System Objects option so that you can view system objects. Open the USysRegInfo table.</li> Add a fourth row to the USysRegInfo table. Fill the collumns with the following information: <ul> SubKey - The same path that is being used in the first three rows.</li> Type - 1</li> ValName - Version</li> Value - One of the values in the table below.</li></ul>

</li> On the Tools menu, point to Add-Ins, and then click Add-In Manager.</li> Find the old version of your add-in in the Available Add-Ins list, select it, and click Uninstall.</li> 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.</li> Open any Access database or Access project, and re-install the modified add-in.</li></ol>

<div class="moreinformation_section">

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.
 * 1) Open the add-in in Access 2000 and when prompted, click the option to convert it.
 * 2) On the Tools menu, click Options.
 * 3) On the View tab of the Options dialog box, select the System Objects option so that you can view system objects.
 * 4) Open the USysRegInfo table. Note there are only three rows in the table.
 * 5) Close the add-in and open the sample project, NorthwindCS.adp.
 * 6) On the Tools menu, point to Add-Ins, and then click Add-In Manager.
 * 7) In Add-In Manager, click Add New. Locate and install the recently converted add-in.
 * 8) Close the Add-In Manager.
 * 9) On the Tools menu, click Add-Ins. Note that the add-in that you just installed does not appear.
 * 10) Close NorthwindCS.adp, and open the sample database Northwind.mdb.
 * 11) On the Tools menu, point to Add-Ins and note that the add-in does appear in the Add-Ins list.

<div class="references_section">