Error while using VBA Code or Macros in Microsoft Access or Excel

Asked By 0 points N/A Posted on -
qa-featured

Hello,

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.

Thanks.

SHARE
Answered By 0 points N/A #151036

Error while using VBA Code or Macros in Microsoft Access or Excel

qa-featured

Hello Warren,

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:

  1. First you will open the Visual Basic Environment (VBE).
  2. And then you will go to the Tools menu and click on References.
  3. 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.
  4. Click OK, and then click to clear the item in the following References list: "MISSING: Microsoft Jet and Replication Objects 2.6 Library."
  5. Click OK, and then go to the Tools menu, and then click References.
  6. 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.

Regards,

Carl

Login/Register to Answer

Related Questions