| re: Greyed out Tools, References option in VBA
I know that you can not change the references in an MDE database. I don't
know whether this causes the Tools : References option to be disabled (and I
don't have Access here to check). Could that be the expanation?
HTH,
TC
"Michelle Collier-Moore" <michellecolliermoore@hotmail.com> wrote in message
news:68f0568e.0310271034.61195786@posting.google.c om...[color=blue]
> Please could someone offer some advice regarding adding references to
> 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...
>[color=green]
> > Open the Debug Window (Ctrl-G) and on the Tools menu, check
> > references. Sounds like your ADO reference is not set.[/color]
>[color=green][color=darkred]
> >>OK, while under the run-time debugger, the "References" >>options[/color][/color]
> 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...
>[color=green][color=darkred]
> >> - Is it possible to reactivate VBA at the local machine?[/color][/color]
> (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[/color]
| 
