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!
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!