Error: 'Error building Report list in Main form. Type Mismatch' When Launching the Directory and Res (NETIQKB7824)

fact
Directory and Resource Administrator 6.x

fact
Microsoft Access XP

symptom
Error: 'Error building Report list in Main form. Type Mismatch' When Launching the Directory and Resource Administrator Reporting Tool On Computers with Access XP Installed

symptom
After creating custom reports and making the appropriate modifications, launching the DRA Reporting Tool on client workstations with Microsoft Access XP installed can generate the error listed above.

symptom
Workstations with Access 2000 loaded function normally.

cause

The References for the Access project that controls DRA reporting has a list of all type libraries.  The Node and ListView types are in two of these libraries and may cause this issue in Access XP.  If Microsoft Windows Control Version 6.0 is above Microsoft Windows Control Version 5.0 in the priority list, the error message is displayed because Version 6.0 has issues with the Node and ListView data types, both of which are used by the DRAReporting Tool.

fix

To resolve this issue, please perform the following steps:

1. Launch the Directory and Resource Reporting tool.
2. Select Enter Design Mode from the File drop down menu.
3. Select Modules from the Objects list.
4. Click the Design button (it does not matter which module is selected).  This which will launch Microsoft Visual Basic.
5. Select References from the Tools drop down menu in the Visual Basic window.
6. Select Microsoft Windows Control Version 5.0 and click the up arrow to move it up the list until it is above Microsoft Windows control version 6.0.
7. Close the Visual Basic window and then close the Reporting Tool.

Once the above steps have been performed the Reporting tool will launch successfully.

This issue is resolved in Directory and Resource Administrator 7.0 and later.

Formerly known as NETIQKB7824