Error:

Compile Error: Can’t find project or library

Symptoms:

When using the VBA Code or Macros in Microsoft Access or Excel, the following error is received “Compile Error: Can’t find project or library”

 Looking at the error message, the most likely cause is that the application has lost the reference to an object or type library, therefore, cannot upload.

Solution:

The problem may be resolved as follows:

1. Open erwin DM application.
2. Open a module in Design view or press ALT+F11 to switch to the Visual Basic Editor.
3. On the Tools menu, click References.
4. Clear the check box for the type library or object library marked as “Missing:”

An alternative to removing the reference is to restore the referenced file to the path specified in the References dialog box. If the referenced file is in a new location, clear the “Missing:” reference and create a new reference to the file in its new location.  Another possibility is that the required DLLs are not registered properly.  See the following for that:

https://support.quest.com/erwin-data-modeler/kb/4288115/error-compile-error-can-t-find-project-or-library-during-upload-from-excel-to-erwin-2019-r1

Related Articles: