ACC2000: Error Messages That Indicate a Missing Reference (231413)

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:

Open your database.
Press ALT+F11 to switch to the Visual Basic Editor.
On the Tools menu, click References.
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

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