'Microsoft.ACE.OLEDB.12.0' provider is not registered -but it is

ms-access 64-bit oledb oledbconnection
Mossi picture Mossi · Mar 21, 2013 · Viewed 13k times · Source

Short and sweet:

  • app works on x86 machine but not on x64 (tried on a 2008 Server and a Windows 8)
  • Microsoft Access Database Engine 2010 already installed (also have Microsoft Office 2007 Access Database Engine installed)
  • MS Office not installed
  • confirmed the existence of C:\Program Files (x86)\Common Files\microsoft shared\OFFICE12\ACEOLEDB.DLL

Code:

string conn = "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;";
OleDbConnection _connOle = new OleDbConnection(conn);

Any ideas what I should do to get this app to work on the x64 machines? Thanks!

Answer

Gord Thompson picture Gord Thompson · Mar 21, 2013

I can think of two scenarios that could explain your issue:

  1. Your C# project is set to target both 64-bit and 32-bit platforms and the 64-bit machine has only the 32-bit version of the Access Database Engine installed. The reference fails because the program is running as 64-bit but the machine is missing

    C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACEOLEDB.DLL

  2. Your C# project is set to target 32-bit platforms only (x86) and the 64-bit machine has only the 64-bit version of the Access Database Engine installed. The reference fails because the program is running as 32-bit but the machine is missing

    C:\Program Files (x86)\Common Files\microsoft shared\OFFICE14\ACEOLEDB.DLL

Note that the installer for the 64-bit version of the Access Database Engine installs just the 64-bit version, not both.

Related questions

Microsoft.ACE.OLEDB.12.0 Provider can no longer open .mdb under Windows 8

I have an x64 application which uses Microsoft.ACE.OLEDB.12.0 provider to read an MS Access Database on Windows 7 (x64) and it works fine (Office 2010 installed). The same application running under Windows 8 with Office 2013 installed, fails with a message saying …

Read More
Hand Install of 64-bit MS Access ODBC drivers when 32-bit Office is present

I want to do a hand install of the MS Access 64 bit odbc drivers. Uninstalling 32 bit Office and installing 64 bit Office is not an option due to the add-ins that our company uses. I downloaded the AccessDatabaseEngine_x64.exe and …

Read More
Winforms Crystal Report - "Failed to load database information" error

I have developed a small crystal reports win forms application that connects to an Access DB in the local network and shows a set of basic reports. I used VS 2010 for this. I used the 'DAO' connectivity method to access …

Read More