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?
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"tom" <(E-Mail Removed)> wrote in message
news:UnCgh.747$(E-Mail Removed)...
> 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.
>