question

RhysMckinnon-9313 avatar image
1 Vote"
RhysMckinnon-9313 asked RoutDeepakKumar-5006 commented

How to fix Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

After trying to follow several solutions online none seem to be working. I'm using 64bit Microsoft access and 2019 visual studio and have already installed the engine from https://www.microsoft.com/en-au/download/details.aspx?id=13255. I've tried running visual studio on x86 and any cpu. Stumped on where to go next

dotnet-adonet
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

...several solutions

Which solutions ?

(BTW, the 2016 version is Microsoft Access Database Engine 2016 Redistributable )
(accessdatabaseengine_X64.exe)


0 Votes 0 ·

Hi @RhysMckinnon-9313 ,
I suggest you can try to use 32bit Microsoft access to check.
Regarding this problem, there are some solutions and suggestions have been provided in this thread.
Best Regards,
Daniel Zhang


0 Votes 0 ·
AbdelmalekAitouche-2691 avatar image
2 Votes"
AbdelmalekAitouche-2691 answered KyleAnderson-8788 commented

Hi gents,

I have gone through the same issue after installing several Access, ADODB runtime redistributables but still had the same problem.
The solution is:
Go to project properties
Compile Tab
Scroll down to Advanced Compile Options
Target CPU: change between x86 , x64 and AnyCPU validate your selection and run debug to test.
I hope this will solve your issue.
Best regards,
A. Aitouche



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

This was helpful as it got me to the right place to look. For me it seemed to be unchecking the box for Prefer 32 bit that did the trick.




3 Votes 3 ·

What about the Exe file?

I have developed the code in one server where the application is running fine. But while I move the Exe to a different server and tried to run that exe after install the MS Access Database Engine software, it's not working there

0 Votes 0 ·
Thomas-0942 avatar image
1 Vote"
Thomas-0942 answered

After some updates of Windows 10 and migration to Office 365 I did this:
- Installing AccessDatabaseEngine_X64.exe (which did not directly solve the issue)
- Visual Studio 2019: Project > <Project_Name> Properties > Target CPU > 'x64'

Thank you A. Aitouche!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.