inGOT Notification #010007

Error reported when opening Reporting database for the first time.

Information in this article applies to:

- inGOT reporting database (created after 2 December 2002)
- Microsoft Access databases only

SYMPTOMS

Error displayed when opening inGOT user database for the first time. Visual Basic editor opens, message displayed: 'Compile Error: Can't find project or library.'

CAUSE

This is caused by incompatibility between versions of the MDAC (Microsoft Data Access Components) library. The reporting console database uses the MDAC v2.6 library, so earlier versions (e.g. v2.1) may cause this error.

RESOLUTION

1. From within the macro editor, stop the macro running* (Press the 'reset' button on the toolbar)
2. Select Tools then References from the menu
3. Look for the entry 'Microsoft ActiveX Data Objects 2.6 library'.  You will see the word 'MISSING:' in front.
4. Make sure this entry is not selected.
5. Scroll down until you find a 'Microsoft ActiveX Data Objects 2.x Library' entry.
6. Select this entry.
7. Press Okay.
8. Close the Macro editor.
9. Close and re-open the database.
10. The Report Console form should now open correctly.

*Follow these instruction if the macros will not stop:

1. Exit the database.
2. Re-open the database while holding down the shift key. (This will stop the macro from loading)
3. Press Alt-F11 to open the macro editor.
4. Go back to previous instructions.

For further clarification please contact the Liverton support team at .

Copyright Liverton Ltd. ©2002