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: http://www.microsoft.com/en-us/download/details.aspx?id=13255

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