Getting error 'Microsoft.ACE.OLEDB.12.0' provider is not registered, however i was loading files earlier

Question

I am getting an error The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. However, I have loaded many files using same service two days earlier. Why this issue has started occuring.

My machine is 64 bit window 7 OS. Every project in .NET solution is configured for ANY CPU.

Answer 1

In the properties of your project try targeting x86 instead of AnyCPU:

Alternatively if you want to target AnyCPU you need to install the x64 bit Access OLEDB provider. You can download it from here.