You may receive the "Microsoft Access can't find the project or library" error message when you compile an Access 2000 database that has been converted to an Access 97 database

Article translations Article translations
Article ID: 241709 - View products that this article applies to.
This article was previously published under Q241709
Novice: Requires knowledge of the user interface on single-user computers.

Expand all | Collapse all

SYMPTOMS

When you compile a Microsoft Access 2000 database that has been converted to a Microsoft Access 97 database, you may receive the following error message:
Microsoft Access can't find the project or library
Note This behavior does not occur on a computer that has both Access 97 and Access 2000 installed.

CAUSE

This behavior occurs if any reference in the newly converted Access 97 database is listed as missing. For example, when an Access 2000 database that is using the Microsoft DAO 3.6 library is converted back to Access 97, the Microsoft DAO 3.6 library reference is retained in the converted database. If this database is then compiled on a computer that only has Microsoft Office 97 or Access 97 installed, you receive the error message.

RESOLUTION

To work around this behavior, follow these steps:
  1. Open the converted database in Microsoft Access 97.
  2. Open a new or existing module in Design view.
  3. On the Tools menu, click References.
  4. Click to clear the check box for the reference marked as MISSING, and then click OK.
NOTE: If the reference marked as MISSING is a reference to the Microsoft DAO 3.6 Object Library, you must set a reference to the Microsoft DAO 3.5 or 3.51 Object Library in order for your code to compile successfully after you remove the missing reference.

If you cannot find an object library equivalent to the one that is missing, you may need to change the code.

MORE INFORMATION

Steps to Reproduce the Behavior:

  1. In Access 2000, open the sample database, Northwind.mdb.
  2. On the Tools menu, point to Database Utilities, point to Convert Database, and then click To a Prior Access Database Version.
  3. Save the new database.
  4. Open the database in Microsoft Access 97 on a computer that does not have Microsoft Access 2000 installed.
  5. Open a new or existing module in Design view, and then on the Debug menu, click Compile and Save All Modules. Note that you receive the error message mentioned in the "Symptoms" section.

Properties

Article ID: 241709 - Last Review: January 25, 2007 - Revision: 4.3
APPLIES TO
  • Microsoft Access 97 Standard Edition
  • Microsoft Access 2000 Standard Edition
Keywords: 
kberrmsg kbprb KB241709

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com