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

Question

0.00/5 (No votes)

See more:

Hi Everyone:
I looked up this error on the internet and I can't find an answer for my situation.

I have two VB.NET projects that use an MS Access 2010 database to retrieve information on how to place a control dynamically on the Form.

The DataEntry project works fine. I can connect to the MS Access database and the form functions as designed. I can read the data from the database and I don't get any errors.

The Uni_DE_Tool project uses the exact same MS Access database and code to retrieve the data, but I get the 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine error.

Both projects are on the same machine, so logic dictates that if one project works, so should the other. Both projects have the same Namespaces and resources included.

Can someone enlighten me as to why this happens? My initial guess would be I am missing some namespace or resource, but I double checked both projects and made sure the Imported Namespaces and Added resources are the same.

Thanks,
MRM256

Posted 20-Oct-13 9:08am

MRM256

Add a Solution

Comments

Maciej Los 20-Oct-13 15:36pm

Check connection string!

1 solution

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)

MRM256 · Accepted Answer · 2013-10-20T09:41:00

Solution 1

I found the answer.

1. Right click on your Project name.
2. Click on the Compile Tab
3. At the bottom of the page click on the button Advanced Compile Options.
4. On the Advanced Compiler Settings page on the Target CPU pull down menu select x86
5. Click OK

You should be able to connect to MS Access DBs using the Microsoft.ACE.OLEDB.12.0 provider.

Posted 20-Oct-13 9:41am

MRM256

Comments

Maciej Los 20-Oct-13 15:47pm

OK. Mark this answer as a solution (green button) - formally to remove question from unanswered questions list ;)