If you have a procedure that contains a Visual Basic for Applications function and your database contains a reference to a missing object library or type library, you may receive one of the following error messages when you compile your modules or run the procedure:. An alternative to removing the reference is to restore the referenced file to the path that is specified in the References dialog box.
In an Access run-time application, you cannot view references from a menu. However, the following article demonstrates how to view references using code: How to loop through references to view their properties.
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. There may be some moldy old, those look like A97 or earlier references code that's using these two libraries.
The code will need to be either removed or rewritten. Try making a backup and commenting out the lines that show up as errors when you compile; if the database still works test it thoroughly!! If not you may need to replace the code with something a decade or two more up to date.
You could post the code here if you need help. Hi Team, I am getting below error while launching MS access I have the same question Report abuse. Details required :. Cancel Submit. Scottgem MVP. You shouldn't need either reference so just remove them.
The Winnt or Windows folder where OS files are functioning. The System folder beneath Windows or Winnt folder. In majority of situations, you search MS Knowledge Base for article regarding precise error note, and you can resolute error by following steps within article. In few circumstances, an addiction file is not appropriately coordinated with primary file. The following list portrays some of reference error messages that you might take delivery of.
You can hunt MS Knowledge Base for piece that defines a variety of shapes of error message. You might even get error message if form or statement comprise of an ActiveX control. Often file is observed as Missing in dialog box of Reference.
Trying to run an Access database on Access It wants dao Someone on another website says it's needed for 97 to or to , but not to If so, how do I get rid of the error message? Monday, September 2, PM. The old 2. Depending on your workload… 1. Find a copy of that file and reference it. Move it to a higher priority than ADO if it is referenced.
0コメント