Home > Solution Categories > Microsoft Office > MS Access > Error while using VBA Code or Macros in Microsoft Access or Excel
Question
No of visitors who read this post: 240
Category: MS Access
Type: Question
No votes yet

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.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

#

Submitted by Carl Jack on Wed, 2012-08-22 04:46. Comment Id: 81534

Hallo 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

Previous Previous Page
117 of 265
Next Page Next