Connecting To mdb from Windows 7 PC

Posted on 2011-05-11
Last Modified: 2012-06-27
I've been battling this problem for almost a month.

I have a VB 2010 application that connects to an Access 2003 Database on the server. I have tried to change the connection string from "4.0" to "12.0" - following EE suggestions, but now I just get the same error "Not Registered on This Machine" only referencing OLEDB.12.0 instead of OLEDB.4.0.

I have found some suggestions on other sites recommending that I download either "AccessDatabaseEngine.exe" or "AccessDatabaseEngine_64.exe" but I want to be sure that what I am doing is configuring the one Windows 7 machine to talk to the 32 bit Access 2003 mdb file, and NOT stepping on the mdb - which is also addressed by numerous users still on Windows XP boxes.

Any step by step assistance would be appreciated.
Question by:Buck_Beasom
    LVL 2

    Expert Comment

    LVL 69

    Expert Comment

    by:Éric Moreau
    are you on Windows 64-bits? the easy answer is to target the x86 platform in your project
    LVL 69

    Expert Comment

    by:Éric Moreau

    Author Comment


    I went to the site you provided and found both drivers - which I had already downloaded earlier.

    I just don't know what to do with them. Do I run the AccessDatabaseEngine_64.exe on the Windows 7 client? Will the provider string then be "12.0" or "14.0"? I have seen both suggested.

    Thanks. (And for help you have provided me in the past!)
    LVL 69

    Accepted Solution

    yes you need to install the engine. because it is the 2010 version, you need to use 14.0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
    More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    759 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

    14 Experts available now in Live!

    Get 1:1 Help Now