Microsoft.ACE.OLEDB.12.0 provider

Question

Hello everyone
I'm currently designing an application in C# and at the same time I'm using databases (with access)
but during compilation, the following message appears: "the Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine." I did some research but couldn’t find anything, I found a sort of solution saying to switch from 64 to 32 bits (x86) but still no result, I get the following message instead: "the specified case is not valid"
So now I don't know what to do, so if someone can help me that would be super coooooooooooooooooooooool
thanks
ps: I’m working with Visual Studio 2008!!!

Configuration: Windows 7 / Safari 533.1

luckyexplorer · Accepted Answer

You need to choose "Target CPU" as X86 instead of "Any CPU" in the advanced compilation options. The driver is not compatible with 64 bits. Once that's done, you won't have this issue anymore.

holow1 · Answer

Hello,   Are you using Access 2003 or 2007 or?

holow1 · Answer

Good evening,  Can you show us the connection chain?

holow1 · Answer

Hello,  I think there's a problem with the connection string, but I didn't understand ./BDC.accdb  and to check your connection string, see here https://www.connectionstrings.com/access-2007/

holow1 · Answer

Hello,Thank you for the explanation. I suggest placing your database in the bin folder of your application.Then modify the connection string.Application.StartupPath + ""\BDC.accdb"

JejeGo · Answer

It is a component to download from Microsoft:
http://www.microsoft.com/downloads/details.aspx?familyid=6C050FE3-C795-4B7D-B037-185D0506396C&displaylang=en

The list of different MDAC and Service Packs:
https://docs.microsoft.com/en-us/previous-versions/aa937730(v=msdn.10)?redirectedfrom=MSDN

It is now available for Office 2010 (to create or access Access and Excel 2010 files):
http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

JD · Answer

Thank you JejeGo,  that's what I call excellent support.   Very useful link.

toto · Answer

Hello,
thank you for this information

but after installing accessdatabaseengine on my PC I still get the same error: microsoft.ace.oledb.12 is not registered on the local machine

if someone can help me

thank you

Thiphariel · Answer

I'm bringing the subject up again, sorry, but indeed, the solution to the problem is to compile in x86 and not in Any CPU!  Thank you

LARAQUIgh · Answer

I THINK THAT THE SOFTWARE DOES NOT SUPPORT ALL THE FILE EXTENSIONS YOU WANT TO IMPORT.

rellian · Answer

Hello,

I also can't add my database to Visual Basic, this message appears: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

I saw that I needed to change the target platform (target CPU) to x86 but I can't find where to change the platform, I don't have it...

Thanks for your help!!!

Microsoft.ACE.OLEDB.12.0 provider

11 answers

Texture issues in enshrouded

Gotek information

Self-invoking js function

My pc won’t charge anymore and runs super slowly

Download software against mcafee pop-ups

My computer stays connected for very little time

Unable to open xsl and xslx files

Archival hard drive no longer appears in file explorer

Samsung wallet

How to pair a receiver with an external speaker without fi