an Access database?
I tried to open a project a few days ago sent to me by someone whose
developer had left the company. I found that I had a reference problem
and went to the usual Tools, References place to fix it. The
References option was greyed out and as I have never seen this happen
before, after trying various things, searching here for an answer etc.
gave up!!
Today I have made some changes to one of my own databases where I have
to prioritise DAO over ADO; I've done this numerous times. Again, the
References option on the menu is greyed out. I've searched here and
found a couple of posts relating to this issue. In particular this
one...
Open the Debug Window (Ctrl-G) and on the Tools menu, check
references. Sounds like your ADO reference is not set.
OK, while under the run-time debugger, the "References" >>options was greyed out. However, checking my Access and >>Computer #2's
Access under design conditions revealed that >>both copies appear to
have identical references checked
I have tried what is suggested above and it is still unavailable.
Another post asks the question...
- Is it possible to reactivate VBA at the local machine?
(Tools|References
is greyed out)
Unfortunately the respondent doesn't answer that question.
I haven't changed the configuration of my machine to "deactivate VBA",
not even sure what that means but I've not had problems in the past.
I've made sure that the "Immediate" window is open; this seems to be
mooted as a possible problem in some posts.
Any ideas?
Regards
Michelle