I am running windows 7 x64 enterprise. I have Office 2010 x64 installed. I am using Delphi XE2. I am trying to compile a program under x64 platform.
How do I connect to my Access database (*.accdb) since there is no provider installed?
If I am not mistaken, there ought to be a Microsoft.ACE.OLEDB.14.0 provider incorporated but it is not. Not even the 12 .0 one (I think Microsoft reverted to the 12 one...).
Now, there's a big dilemma ...I can not use Access under x64 since there is no provider. And Access 2010 x64 supposedly produces an 64 database.Result, the database is not readable on x32 system. So, how on earth do I connect to it ? I tried using Unidac and it connects very nicely to a *.mdb database.How it does that under x64 platform I really do not know. But it works.But since I usually hardcde database connection string, I do not know how to do that for the UniConnection. So if someone knows,please enlighten me ...
so I guess this is the answer : download access 2007 driver and install.