Monday, June 27, 2016

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

Hello guys, have you ever seen
or heard this error before ?
okay, maybe you would get this
error when you use the latest
of microsoft access (2010/2013)
and you try to make a database
connection from it to VB.Net. 2008
So, how to solve it ? same as I did,

first, you can try to change the target CPU. how ?
right click on your project name --> properties --> click compile tab --> advanced compile options --> change the target CPU to x86.


But if it doesn't work, you have to do this :
if you use Ms. Access 2010, you have to uninstall it then install Ms. Access 2007 or Ms. Access 2013.
second, if you choose to install Ms. Access 2007, your problem would be solved.
But, if you want to install Ms. Access 2013 then ,you have to install AccessDatabaseEngine 2007 too.
here is the link download AccessDatabaseEngine2007.
Trust me it works.