Visual Basic for Applications (VBA) functions break in a database with missing references
This article applies to a Microsoft Access database (.mdb and .accdb) and to a Microsoft Access project (.adp).
For a Microsoft Access 2000 version of this article, see 208218.
Error message 1
* To ensure that your database or project works properly, you must fix this reference.
* To learn how to fix this reference, click Help.
Error message 2
Can't find project or library
- Open your database.
- Press ALT+F11 to open the Visual Basic Editor.
- On the Tools menu, click References.
- Click to clear the check box for the type library or object library marked as MISSING: <referencename>.
NOTE: In an Access run-time application, you cannot view references from a menu. However, the following article demonstrates how to view references using code:
Steps to Reproduce the Behavior
- Open the sample database Northwind.mdb.
- Create a new form that is not based on any table or query.
- On the Insert menu, click ActiveX Control.
- In the Select an Activex control list, click Kodak Image Edit Control, and then click OK.
- Save the form as frmReference, and then close it.
- Close Northwind.mdb, and then quit Access.
- Find and rename the ImgEdit.ocx file to ImgEdit.old.
- Start Access, and then open Northwind.mdb.
- Open the Startup module in Design view.
- On the Debug menu, click Compile Northwind. Note that you receive both of the error messages that are mentioned in the "Symptoms" section of this article.
- Click OK. Note that the References dialog box appears; the following reference is highlighted in the Available References dialog box:
MISSING: Kodak Image Edit Control
- Click Cancel in the Available References dialog box.
- Find and rename the ImgEdit.old file to ImgEdit.ocx.
- Repeat step 10 and note that the error message no longer appears.
Article ID: 283806 - Last Review: 07/12/2013 07:15:00 - Revision: 5.6
- kbproductlink kbfunctions kbvba kberrmsg kbprb KB283806