"Microsoft.Ace.Oledb.12.0" Cannot Be Loaded In-Process on a 64-Bit SQL Server

Microsoft.ACE.OLEDB.12.0 cannot be loaded in-process on a 64-bit SQL Server

As it turns out, you can get the 64-bit driver from here.

https://www.microsoft.com/en-us/download/details.aspx?id=13255

After you download it, don't double-click it to install it, install it using the command prompt, which should be something like this:

"C:\Users\rshuell001\Downloads\AccessDatabaseEngine_x64.exe" /passive

The '/passive' is the key here because it prevents the installation from failing if you already have the 32-bit version installed (via 32-bit Office).

The OLE DB provider Microsoft.ACE.OLEDB.12.0 for linked server (null)

http://www.aspsnippets.com/Articles/The-OLE-DB-provider-Microsoft.Ace.OLEDB.12.0-for-linked-server-null.aspx

This solves the issue.
For some reason SQL Server does not like the default MSSQLSERVER account. Switching it to a local user account resolves the issue.

Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Well, you need to install it. You're looking for:

• The 2007 Office System Driver: Data Connectivity Components.

Microsoft.ACE.OLEDB.12.0' 64x Sql Server and 86x Office?

Looks like Microsoft hasn't come up with a solution on this yet.
check Microsoft feedback form of products

They have some workarounds like using SSIS

---

Related Topics