The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered error with Vista 64bit
If you’re getting this error while trying to connect to Access 2007 or Excel 2007 via the Office 12 OleDB provider, you must first make sure you have the Office 2007 data providers installed.
Next, under x64 (64bit), the data providers will not work by default as they are 32-bit only (x86), even if the data providers download page doesn’t say it. You have to explicitly compile for x86 instead of the default “Any CPU” platform:
The solution is to add a new configuration for x86 platform in VS (click on Configuration Manager shown above), and build with explicit x86 target platform. This will force 32bit runtime and therefore will be able to load the provider on the 32 bit process.
/kzu
/kzu dev↻d