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.

Error message when you import modules, reports or forms to Access 2002 or Access 2003: "Your Microsoft Access database or project contains a missing or broken reference to the file FileName version VersionNumber"


View products that this article applies to.

Symptoms

When you import a module, a report or a form from an Access 97, Access 2000 or Access 2002 database to an Access 2002 or Access 2003 database, you receive the following error message:

Your Microsoft Access database or project contains a missing or broken reference to the file FileName version VersionNumber.

The FileName is the name of the .dll file or the .tlb file, and the VersionNumber is the version number of the file.

This problem occurs when all of the following conditions are true:
  • The module, report or form in the source Access database contains a reference to a DLL (.dll) or to a type library (.tlb).
  • The DLL (.dll) or the type library (.tlb) does not exist in the same location on the source computer as that on the destination computer.
However, when you open the module in Design view, or open the code window for the report or the form, and then you verify the list of references, you can not find any reference that is marked as missing.

↑ Back to the top


Resolution

If the reference to the FileName is not required for the code to run correctly, you do not have to take any action.

However, if the reference to the FileName is required for the code to run correctly, you must create a reference to that library or to an updated version of that library. For example, if the message refers to the Dao2535.tlb file, you can refer to the Microsoft DAO 3.6 Object Library.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top


More information

If your computer does not have a .dll file or a .tlb file that a module in an Access database or in an Access project requires, the broken reference appears with the keyword missing in pre-Access 2002 versions. However, Access 2002 and Access 2003 does not display the missing reference.

This behavior occurs when the reference is in a standard module or in a class module of a form or of a report. With a class module, if the broken reference is not listed in the list of references, the error message does not appear during the import process.

↑ Back to the top


References

For more information about how to add references, click Microsoft Microsoft Office Access Help on the Help menu, type references in the Search for box in the Assistance pane, and then click Start searching to view the topic.

↑ Back to the top


Keywords: KB824259, kberrmsg, kbprb, kbimport

↑ Back to the top

Article Info
Article ID : 824259
Revision : 3
Created on : 9/17/2011
Published on : 9/17/2011
Exists online : False
Views : 372