The 'microsoft.ace.oledb.16.0' provider is not registered on the local machine

Question

0.00/5 (No votes)

See more:

While working on a project, I am trying to connect to MS Access DB using in Visual Studion IDE but whenever I run the program, the chrome browser displays that 'Microsoft.ACE.OLEDB.16.0' is not registered.

I've been through many sites to resolve the issue but it has not been solved yet.

I am working on Office 2016, windows 10 (64 bit).

What I have tried:

I have downloaded the comp-ability and distribution platforms from the Microsoft websites but the issue doesn't seem to be solved still.

Posted 27-Feb-17 2:15am

Member 12164050

Updated 27-Feb-17 9:46am

Richard MacCutchan

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2017-02-27T08:46:00

Solution 1

You have to download and install Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center[^] to be able to use it in your project.

Posted 27-Feb-17 8:46am

Maciej Los

Dave Kreskowiak · Answer 2 · 2017-02-27T09:46:00

A couple of things...

First, Which version of Office 2016 do you have installed? If it's the 32-bit version of Office, your application has to be compiled for a Platform Target of x86, NOT AnyCPU. Go into your Project Properties and click on the Build tab, you'll find it in there.

If you've got Office 2016 Click-To-Run installed, you have to install a separate Access runtime. Like above, you can either install the 2010 version or the 2013 version. It really doesn't matter. (If you try to install the 2016 version it'll tell you that you can't install it because you already have 2016 Click-To-Run installed.)

Once you have that install you have to change your connection string to use the correct version of the ACE engine. For the Access Runtime 2013, it's 'Microsoft.ACE.OLEDB.15.0'. For Office 2010, it's 'Microsoft.ACE.OLEDB.14.0'.