Microsoft KB Archive/231413

= ACC2000: Error Messages That Indicate a Missing Reference =

Article ID: 231413

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q231413



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
If you have not set the appropriate references in Access 2000, you may receive one of the following error messages when you run code that includes an object from a missing reference:

Variable not defined.

-or-

Run-time error '5':

Invalid procedure call or argument.

-or-

Microsoft Visual Basic

The library which contains this symbol is not referenced by the current project, so the symbol is undefined. Would you like to add a reference to the containing library now?

-or-

Compile Error: Can't find project or library.



CAUSE
Your database contains a reference to a database, a type library, or an object library that is marked as MISSING: in the References dialog box.



RESOLUTION
Be sure that you include all required references. To check for and remove missing references:


 * 1) Open your database.
 * 2) Press ALT+F11 to switch to the Visual Basic Editor.
 * 3) On the Tools menu, click References.
 * 4) Any check boxes that are marked as MISSING: indicate a missing reference. Click to clear the check box for the type library or object library marked as MISSING:.

An alternative to removing the reference is to restore the referenced file to the path that is specified in the References dialog box. If the referenced file is in a new location, clear the MISSING: reference, and then create a new reference to the file in its new folder.



MORE INFORMATION
The references that are selected by default at the time a new Microsoft Access 2000 database is created are as follows:
 * Visual Basic for Applications (VBE6.DLL)
 * Microsoft Access 9.0 Object Library (MSACC9.OLB)
 * OLE Automation Library (STDOLE2.TLB)
 * Microsoft ActiveX Data Objects 2.1 Library (MSADO15.DLL)

Steps to Reproduce the Behavior
 Open a new database. Insert a new module. On the Tools menu, click References. Make sure that there is no reference to the Microsoft Office 9.0 Object Library.  Type the following procedure in the module, and then press F5: Sub Test MsgBox Application.LanguageSettings.LanguageID(msoLanguageIDUI) End Sub 

Additional query words: prb run time error 5

Keywords: kberrmsg kbprb KB231413

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.