Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 824259 - Last Review: May 30, 2006 - Revision: 2.2
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"
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft
Access project (.adp).
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.
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.
STATUS
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
at the beginning of this article.
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.
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.
APPLIES TO
- Microsoft Access 2002 Standard Edition
- Microsoft Office Access 2003
| kbimport kbprb kberrmsg KB824259 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please