Error on loading DLL in Access Query Wizard

G

Guest

When I have a table in a database and try to open a new query using the
wizard, the error comes up twice saying there is an error on loading DLL. I
have tried all I know to do. Take Office 2003 Professional off, put it back
on with full application installation, use the cd for Access 2000 but it does
not work either. When I run the same file on another computer without the
Office 2003 I have no problem. Can anyone suggest a remedy.
 
T

Tom Ellison

Dear Lola:

I can only suggest you might try what I would probably attempt. This is
based on a guess that you have a corrupted file for one of the references,
which is where DLLs come into play.

Open any form in design veiw and click the "code" icon. Then select
Tools/References. This is a list of all the "references" to DLLs.

Unless you (or are there others?) have set up unusual requirements, you
should see 5 lines of references at the top that are checked. Is this the
case?

If not, please report back here with the names of the checked references.
I'll try to suggest one that may be most likely to be a problem.

To isolate which one of the references may be a problem, uncheck these one
at a time. You'll need an accurate record of which ones were originally
selected so you can replace them if they prove to be at fault.

When you uncheck a reference, it may cause a "missing reference" message.
This may occur in addition to the existing error message. In that case,
according to my theory, it would mean that you have created a new problem.
But, at some point, if this works as I'm expecting, you will not get the two
previous messages. You may get none, or only one of them. That would mean
you have removed the reference to a corrupted DLL, which you would then know
to replace. You'll need to get this from a CD or by downloading it. The
path and filename appear in the references window for each one, so that
shows you which corrupted file needs replacement, and where to put it.

It is my understanding that you can replace a corrupted DLL file by
overwriting it, and there would be no registration issues.

If you have more than the typical (default) 5 references, then likely
someone who wrote the software has found a need for some other DLL
functionality. This should be done with their assistance if convenient.

Another approach, probably easier, is to try the same thing on another
computer. Likely the problem will disappear. A file compare of the 5 pairs
of DLLs should then locate the faulty one, and a copy from the good one to
the bad one may fix this problem.

You might want to cause and copy the exact error message into your next
message in case that might give someone here a clue.

Proceed carefully. Without making any changes, you should do nothing that
changes the system until you have isolated the problem and are quite certain
you know what the problem is.

Tom Ellison
 
G

Guest

I found the solution yesterday at 2 pm. There was a download to survey the
match, mismatch and no match where I saw something about a missing Jet?. I
then went to a MS search for that download made sure I had the correct OS and
put that on the hard drive. The error was gone!

I would be happy to answer all your questions but the problem was on another
hard drive and since it has been repaired the answers about the Code
references should be in working order. Thank you very much!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top