Solved MS Access 2007 VBA "Unable to load dll" (1 Viewer)

oldaf294

Registered User.
Local time
Today, 00:42
Joined
Mar 29, 2002
Messages
91
A few days ago I began receiving the error, "Unable to load dll." I've tried everything in my meager knowledge to solve the problem: Repair the Office 2007 Pro Plus, Uninstall Office 2007, reinstall. Decompiled the accdb (I think), recompile. I even tried deleting the module entries to start over, but I ended up with several blank Modules and nothing listed in the sidebar for Modules. I'm at a loss as to what to do now? In a copy of the database, when I click a listing in the Modules section, I get a msg about missing network. Or a msg box about "File not found." The DB is on my local C:.
 

Gasman

Enthusiastic Amateur
Local time
Today, 00:42
Joined
Sep 21, 2011
Messages
14,048
Look in Tools/References? in the VBA window for anything Missing?

Work on a COPY until you get to the bottom of it.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 08:42
Joined
May 7, 2009
Messages
19,169
your db is corrupt.
better to reinstate your backup db.

it is a good practice to, once in a while,
import all objects to a New db.

corruption can occur if you edit your db
in newer msa.
 

oldaf294

Registered User.
Local time
Today, 00:42
Joined
Mar 29, 2002
Messages
91
Same thing happens to my backup copy and a Video.accdb I downloaded from a webpage.
 

oldaf294

Registered User.
Local time
Today, 00:42
Joined
Mar 29, 2002
Messages
91
Thanks, Gasman: I checked the references and the 4 checked are;
Visual Basic For Applications
Microsoft Access 12.0 Object Library
OLE Automation
Microsoft Office 12.0 Access database engine Object Library
Don't know what else should be checked?
 

ypma

Registered User.
Local time
Today, 00:42
Joined
Apr 13, 2012
Messages
643
Olddaf294, If not your References , the DLL File could be damaged due to hard disk error, Have you tried the debase on another Pc ?

If the error occurs on start up the fault might be in the Start up module .
Hope this is of use to you

Regards Ypma
 

isladogs

MVP / VIP
Local time
Today, 00:42
Joined
Jan 14, 2017
Messages
18,186
Two questions:
1. Which specific DLL file is causing the problem?
2. Can you open the file using the shift bypass to prevent any start up code running?
 

oldaf294

Registered User.
Local time
Today, 00:42
Joined
Mar 29, 2002
Messages
91
Isladogs,The message box doesn't specify. No, I haven't.
 

isladogs

MVP / VIP
Local time
Today, 00:42
Joined
Jan 14, 2017
Messages
18,186
1. Strange - it should tell you.
2. No you haven't tried or no you can't do so?

If you can't open it using shift bypass, its probably corrupted.
As you've already tried decompiling, the next step is to try and import all objects to a new blank database
 

oldaf294

Registered User.
Local time
Today, 00:42
Joined
Mar 29, 2002
Messages
91
Not 100%, but I deleted all copies on the he and importated tables only into a new db. No problems with forms, however, queries are a problem. When I try to use the query wizard it freezes at field selection and I have to use Task Manager to close. I'll mark this solved.
 

Users who are viewing this thread

Top Bottom