ACC2000: Error Messages That Indicate a Missing Reference

This article was previously published under Q231413
This article has been archived. It is offered "as is" and will no longer be updated.
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: <referencename> 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: <referencename> indicate a missing reference. Click to clear the check box for the type library or object library marked as MISSING: <referencename>.
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: <referencename> 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

  1. Open a new database.
  2. Insert a new module.
  3. On the Tools menu, click References. Make sure that there is no reference to the Microsoft Office 9.0 Object Library.
  4. Type the following procedure in the module, and then press F5:
    Sub Test()   MsgBox Application.LanguageSettings.LanguageID(msoLanguageIDUI)End Sub					
prb run time error 5
Properties

Article ID: 231413 - Last Review: 12/05/2015 14:27:53 - Revision: 2.0

Microsoft Access 2000 Standard Edition

  • kbnosurvey kbarchive kberrmsg kbprb KB231413
Feedback