asked on

What are the DLL's that Access 2007 references for CurrentDB?

What are the DLL's that Access 2007 references for CurrentDB?

I need to know what DLLs Access 2007 uses to function properly, and/or a way to trace what DLL is giving a generic "Error Loading DLL" message upon attempting to run code.

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Run this and see what turns up:

MDAC Component Checker:

http://www.microsoft.com/downloads/details.aspx?familyid=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en

mx

ASKER CERTIFIED SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Scott McDaniel (EE MVE )

What code is giving you the error?

VoodooFrog

ASKER

I found that I was missing the DAO folder under "Common Files\Microsoft Shared".
I gave the points to DatabaseMX for his quick response.

Thanks you both for responding!

VoodooFrog

ASKER

Oh and for anyone who may have the same issue, after copying the DLL's to the appropriate location you must register them. (Also if they are already there and you have a DLL error on DAO objects try reregistering this dll)

Start
Run
CMD
In command prompt type:
regsvr32 "C:\program files\common files\microsoft shared\dao\dao360.dll"
A dialogue box telling you it is registered successfully should appear, and you're done.

Scott McDaniel (EE MVE )

There are quite a few more files needed for DAO to run correctly, so while your particular instance may function correctly the copy & register scenario you suggest is NOT the recommended method - that's where the term "DLL hell" came from, when you install mismatched files (dll, ocx, etc) without going through the correct channels.

Here's some info getting the correct version of DAO:
http://support.microsoft.com/kb/239114