N/APosted on - 08/21/2012
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 forward for your replies.
Error while using VBA Code or Macros in Microsoft Access or Excel
To resolve that problem, you will need to go to the computer that has got MDAC 2.5 on it, and then click to clear the Microsoft Jet as well as the Replication Objects 2.6 Library check box, and after that you will need to add a reference to the Microsoft Jet as well as Replication Objects 2.5 Library using the following steps:
First you will open the Visual Basic Environment (VBE).
And then you will go to the Tools menu and click on References.
You will get the following error message: Your Microsoft Access Database or project contains a missing or broken reference to the file 'msjro.dll' version 2.6.
Click OK, and then click to clear the item in the following References list: "MISSING: Microsoft Jet and Replication Objects 2.6 Library."
Click OK, and then go to the Tools menu, and then click References.
In the list of available references, you will need to choose the Microsoft Jet and Replication Objects 2.5 Library check box, and then click OK.