Web Development

Ask something
Discussion Locked

VB: Error in loading DLL

0 helpful
5 replies

by bsadler

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I've had an Access application working for about 2 years, until this morning! Now I get "Compile error: Error in loading DLL" when I try to run it.

I should preface this by saying I'm tech savvy, but know next to nothing about VB.

Nothing changed. I think.

The only thing that might have changed is that I was working on another Access db project that I was trying to get some borrowed VB work in. While I was trying to get it to work I was monkeying with the Reference Libraries because some comments made in another support forum made me believe I needed DAO instead of ADO.

By changing reference libraries in one Access db did I hork up the other Access db?

Yeah, it does sound like something isn't set up right, but it had been working fine Friday morning.

Could the DLL(s) have gotten corrupted or something, or moved somehow? Where are they normally located?

Just to clarify, what I mean by reference library is when you go to Tools and References and add or change the "references" like the Microsoft ActiveX Data Objects 2.1 Library.

Thanks!

Belden

5 replies

by thamer

Eventhough VB doesn't appear to be your problem, reinstalling it along with its SPs will solve your problem... trust me.

by bsadler

Thamer,

Thanks for the suggestion, but I'm not running a seperate VB program. I've only got the functionality that comes with Access. I tried reinstalling Office XP, but nothing.

Belden

by madestroitsolutions

Well, evidently, your program is trying to load a DLL and it fails. Try this:

Go to the references window and look for something like this in the libraries that are checked:

Name of some DLL Library (MISSING)

If you see this, it means your program is referencing a library which could not be located. Once you spot that, find the library (if it was moved or something) and place it where its supposed to be. DLL's usually lie in WINDOWS\SYSTEM32\

If this is not the case and you dont see any (MISSING) libraries in the references, then you might want to try other things. Another thing I would suggest is to [re]install the latest version of ADO.

One final thought, AVOID using components you find here and there. They usually mean TROUBLE.

Good Luck!

by bsadler

Thanks juanja01,

You reminded me to reinstall some of the things that I know have helped fix other Access db type problems in the past. In this case I reinstalled "Jet 4.0 Service Pack 3 Update". Doing this reinstalled whatever was "missing".
Belden

This discussion is closed to new replies.