Microsoft Access Error in Loading DLL

Posted on 2012-08-17
Last Modified: 2012-09-23
Good day everyone
Just migrated to a new system, running Windows 7 Pro 64 bit and Office Professional Plus 2007. When trying to open up an Access Database that was written in Access 2003 I am confronted with an error in the Switch Board Form, "Compile Error: Error Loading DLL", see attached screen shots from the debugger console in Access.
I have looked at the MS KB site and the MSDN KBs area and manually regesitered 2 dlls that were referenced to no avail. The 2 dlls are: dao360.dll and msado15.dll. I have tried to do a convert and save as to Access 2007 format and the error still exists. The compile option in the debugger console is grayed out so I have not been able to re-compile this form in an attempt to correct the error. (that was suggested in one of the MS developers forums). I can open this database on a Windows 7 Pro 32 bit machine running the same version of Office.

Thank you in advance
Question by:EICBOB
    LVL 65

    Expert Comment

    by:Jim Horn
    My guess is that the Windows 7 install also installed higher versions of DAO and ADO on your box.  To verify, open your Access app, go into any code module, go into Tools:References, and see if t...
    (1)  There are references to DAO and ADO with a prefix of 'MISSING: ', and
    (2)  When you scroll down there are higher versions of DAO and ADO.

    The most likely path to success is to uncheck the previous versions, check the new versions, then test your app to make sure it works as expected with the newer versions.

    Another path, although less solid, is to grab those files off of someone else's box, put them on yours, register them manually, and see if your Access app works.

    Hope this helps.

    Author Comment

    Will give it a try and let you know...

    Author Comment

    Hi Jim
    I tried your suggestion and did not see any referances to "Missing" entries, the 2 dlls I manually registered were copied from a Windows 7 system that does open the database with out error.
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    Note that Some Access code needs to be modified to work in 64 bit environments.
    Like this:

    Author Comment

    Addendum to my earlier post about 32 bit versus 64 bit, using another 64 bit system that was built from a corporate image the database opens as expected. I am having an uneasy feeling that something might have not installed properly in the machine that refuses to open the database with out erroring out. The system in question was a "Clean load" as opposed to the image supplied to us. Clean meaning using the OEM install DVD from the manufacturer to load the OS and then using a MS factory install disc for Office.
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    keep us posted

    Accepted Solution

    Ok here is the latest, I took the Office 2007 install disc, re-ran the installation procedure, went to MS Update, applied the updates once again and now the database opens normally. (hmmmm??!!)

    Author Closing Comment

    Although thie final solution that corrected the issue, nothice I did not say fixed, was a re-install of the application suite, I still wonder what was at the bottom the pile so to speak.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Many companies are making the switch from Microsoft to Google Apps ( Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now