Access suddenly works "poorly" on one machine

[Guest]

I have a machine on our network on which Access no longer works right. I say
"right" and that's about all I can say, because it is suddenly doing odd
things. The same database project (MS2003, ADP) works fine on other machines
on the network.

Errors include:

1) every attempt to save a change results in an error saying the data was
changed but the row will be filtered out of the display. This is in fact not
true, but the row turns into a bunch of #NAMEs until you refresh

2) access to Excel, from which I import a file, no longer works. The code
sets up an excel object and then sends it "Worksheets(1)". Now, suddenly, it
states that Worksheets(1) is not a valid object. It works fine on other
machines.

Any ideas?

Maury

 

[Douglas J. Steele]

Did you recently install some new software on that machine? This sounds like
a problem with the References.

On the machine where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). 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 All Modules), 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)