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

Asked By Warren Donaldson 0 points N/A Posted on - 08/21/2012

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.

• Status: Open
• Question Views: 1166
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Carl Jack 10 points N/A #151036

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

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

About Carl Jack

Questions
1

Answers
1657

Best Answers
417

• Vote Up 0 Vote Down

• Posted on - 08/21/2012
• Question Category: MS Access