Broken Reference error message

T

tom

This is the broken reference error message I am getting,
and I have no idea how to fix it. The references
dialog box is not enabled but I would still have no
idea if it was. It apparently is choking on the mid
function for some reason. Surprisingly the program
loads a much larger program with no apparent problems
as of yet.

The application you are attempting to use has a reference it cannot resolve
to an object, type library, DLL, or external database. Either the object,
type library, DLL, or database was deleted or its name has changed. Examine
the Available references list in the References dialog box in the Visual
Basic Editor (Tools menu) to determine if any action is required. If you did
not create this application, contact the programmer or administrator of the
system.
If the reference listed in the Available references list is preceded with
"MISSING:" clear the check box to remove the reference if it is no longer
required. If you still need to use the reference, clear the check box entry
for "MISSING: <referencename>" in the Available references list, and then
create a new reference to the file using the Browse... button. If this is an
installed database application, you may need to reinstall or repair the
application.
More information about this error message online.
 
D

Douglas J. Steele

I already answered this for you.

Assuming that this is an MDB, try holding down the shift key while you're
opening the database: that will prevent any start-up code from running.

Once you've done that, go into the VB Editor (Alt-F11). Select Tools |
References from the menu bar. Examine all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile, under the Debug menu), go
back in and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

If it's an MDE, unless you have access to the original MDB file, there's not
a lot you can do.

What part of those instructions do you not understand?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top