http://blogs.clariusconsulting.net/kzu

Daniel Cazzulino's Blog

Go Back to
kzu′s Latest post

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:


AnyCPU

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.


NewConfiguration

x86Configuration


VSx86

Comments

8 Comments

  1. 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

  2. Muito obrigada, você resolveu o meu problema!

  3. “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.

  4. hello

    i have windows 7 64 bit
    and i hav visual studio 2010 32 bits n m trying connect it to micorsoft access database n i have ms office 2010 32 bits

    i have set the dsn usin odbcad32.exe plus i have downloaded the microsoft acees database engine

    still i am getting the same error of The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered

    PLEASE HELP :( :(:(

    • I have the same problem… you can not connect to Access 32 bits in a 64Bits OS because providers of 64 bits does not exist. Your application is a 64B so it will look and work with drivers of 64bits

      if you find a work around please, please let me know !!!

      JM

  5. Thanks dude. Your tip helped a lot. Appreciate it.

  6. hi,
    i am a problem in vb2010 data saving or update in accdb(Access 2007) database, Please say this how solve this problem,