Broken Reference? Works on other computers

[tom]

I just installed Access 2003 on a computer. When
I try to start a program on it it immediately chokes
and complains about a broken reference.

After this the program starts up but then it chokes
again on the mid function. I read how to read this
error, but I cannot even get the references dialog box
to let itself be selected. And after looking at what
happens on another computer. I dont think I would
understand what to do even if I could.

 

[Douglas J. Steele]

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.