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.
real funny!
imagine, we’re trying hard to get a real 64bit app to run and then …
>> The solution is to add a new configuration for x86 platform in VS <<
ridiculous
s
Muito obrigada, você resolveu o meu problema!
“microsoft.oledb.12.0 provider is not registered on local machine” -msg appears when i connect access with vb 2008 express editon while saving data.
please, suggest me.