


Restart MS Access and check if you encounter the same error anymore or not. Step 4: In the next dialog box, uncheck the “Missing: Microsoft Access Object” and click “Ok” to save your changes. Step 3: Now, click the “Tools” button at the top menu bar and select “Preferences” from the drop-down menu. Step 2: Now, simultaneously press “Alt” + “F11” to launch the VBA editor window.

Step 1: Launch MS Access on your PC and open the Database/Application that’s showing the error. To do so, you can follow this step-by-step process. The first solution to fix the “ excel can't find project or library” error in MS Access is to remove a library reference. Adding or Removing a Reference to a Library The reason is the same, i.e., an object or type of library is missing (or not found).

When you run this project in MS Office 2003, the same compilation error appears. Another scenario for the same error message concerns the use of Microsoft XP, which includes a reference to web service in the VBA project. So the program fails to find the corresponding library, thus issuing this compilation error.Ĥ. For example, the user may have a library (sat Outlook) version of 2007, but the code's reference may be looking for the 2010 version of that specific library. The other possible reason, in that case, is that library miss-match is the cause of the error. Since there are standard libraries, so missing a library sounds a bit of the least chance. Sometimes a library may be toggled or toggled off, causing a missing link between the library and program code. Accordingly, the program cannot use VB or Micro based functions or buttons. The reason is that the program has a reference to an object or type of library which is missing and hence not found by the program. This error is usually caused by the user's MS Access or MS Excel program. When using MS Excel document or MS Access that assimilate functions or buttons which need VBA (Visual Basic Applications) for the Macros to perform some assigned task, the user may get a compilation error "Can't find project or library." What is the cause of this Error?ġ.
