Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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.

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


Keywords: KB241709, kbprb, kberrmsg

↑ Back to the top

Article Info
Article ID : 241709
Revision : 7
Created on : 1/25/2007
Published on : 1/25/2007
Exists online : False
Views : 326