Access Visual Basic Application

Posted on 2014-08-22
Last Modified: 2014-08-22
I'm creating an application using Visual Basic 2013 and Access 2013.  When I try running the application in the Visual Studio IDE  I get an error:

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

How do I fix this???
Question by:rgturner
    LVL 119

    Accepted Solution


    Author Comment

    That did not work.  Got the same error message.
    LVL 40

    Expert Comment

    by:Jacques Bourgeois (James Burger)
    In the Compile tab of the project's Properties window, set the Target CPU to x86.

    Author Closing Comment

    Finally got it to work.  Simply installing the AccessDatabaseEngine_x64.exe did not work.  I had to launch Excel 2013 and perform an import from Access database (accdb) to register the dll.  Now it is working fine.  I'm not sure if this was the best way; however,  it worked.

    I wonder if there is a way to automatically register the dll?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
    It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    737 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

    20 Experts available now in Live!

    Get 1:1 Help Now