Error in loading dll - Access 2010/Windows7

Posted on 2011-05-12
Last Modified: 2012-05-11

Computer configuration :
- Windows 7 pro
- Office 2010
- 32 bits
- Back SQL Express
- Front Access .accdb

We upgraded from Office 2007 to Office 2010. Everybody is fine except one.
On this exception, I can open the software (.accde), my login form appear, then I write my username and password and when I click on the button "Login" I have an error message : Error in loading .dll on the ODBC connection line. I can also have this error message when I try to link my external tables to the front (Access).
Even if the message appear with a .accdb version I can access to the tables,data, forms queries...

What I did :

- Install all the Windows updates
- Re-create an .accde version
- Compare the references with an other computer
- Re-create the ODBC connection

The error is still there...

Do you have a suggestion ?

Thank you very much !

Question by:SirTKC
    LVL 21

    Accepted Solution

    Have you tried running the detect and repair?

    AFAIK, in Access 2010 the only way to run it is with VBA code:


    Open in new window

    Windows 7 32 or 64 bit?
    What SQL Server Version?
    Which ODBC Driver?
     ODBC Drivers
    LVL 3

    Author Closing Comment

    Run & Repair did the job.

    Thanks !

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
    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 …
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    760 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

    11 Experts available now in Live!

    Get 1:1 Help Now