I
in-over-his-head-bill
I think I am missing some .dll file or something (I recently "cleaned-up" my
computer and could have gotten rid of something I shouldn't have)
Formerly working Access 2002 features like the Documentor no longer work --
I get "activex component can't create object" message. Similary, I get that
message with a Error 429 when running the following line of code in a VBA
module that used to work:
zz = CurrentDb.CreateQueryDef(qname$, sql1$)
where qname$ contains the query name I am creating and sql1$ the sql code.
The checked references in VBA are the same as they were before the problem
started.
I have tried reinstalling Access 2002 from the Office XP Professional cd but
that did not fix the problem.
Any suggestions how to figure out what files I need and where to get them or
do I have another problem?
Thanks
computer and could have gotten rid of something I shouldn't have)
Formerly working Access 2002 features like the Documentor no longer work --
I get "activex component can't create object" message. Similary, I get that
message with a Error 429 when running the following line of code in a VBA
module that used to work:
zz = CurrentDb.CreateQueryDef(qname$, sql1$)
where qname$ contains the query name I am creating and sql1$ the sql code.
The checked references in VBA are the same as they were before the problem
started.
I have tried reinstalling Access 2002 from the Office XP Professional cd but
that did not fix the problem.
Any suggestions how to figure out what files I need and where to get them or
do I have another problem?
Thanks