Connection Error between 32-bit and 64-bit office on the same OS

Hello there,

I have developed an application and throughout looking on the web, I couldn't find the solution to my problem.

I am using Visual Studio 2013, Office 2010 32-bit and Win7 64-bit to develop it and all works fine when I publish it and run it.

Here's my connection string:

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & filePath & ";Jet OLEDB:Database Password=xxx;"

When I try to use my application on a Win7 64-bit with Access 2013 64-bit, I am getting the "The 'Microsoft.ACE.OLDDB.12.0' provider is not registered on the local machine." error. I have tried installing both the file on this page without any success:

When installing the 32-bit version, of course it gives me a corruption error because it's not compatible, but when I install the 64-bit version it just gives me the same error.

Please help me find what I'm doing wrong!

1 answer

I have fixed my problem. After reading about what ACE.OLEDB.12.0 is, I switched to "Provider=microsoft.Jet.OLEDB.4.0;Data Source=C:...;".

Thing is 12.0 is not installed on Windows by default while Jet is. So I made my database into a 2003 version in order to be able to use Jet and it worked!