2574647 - How to install 32 bit Excel database engine with 64 bit MS Office already installed

• How to install 32 bit Excel database engine with 64 bit MS Office already installed?
• You cannot install the 32-bit version of Microsoft Database Engine 2016 because you currently have 64-bit Office products installed

• SAP Crystal Reports 2016
• MS Office 2016 64 bit

1. Install the 32-bit Microsoft Database Engine 2016

• Microsoft does not support installation of 32 and 64 bit Database Engines on the same machine

• According to the following Microsoft blog: Microsoft Access Database Engine OLE DB Provider

If you are in a scenario where you have both 32-bit and 64-bit processing being performed on the same server that needs to use the ACE data provider, from the Microsoft standpoint, it is recommended to have 2 different servers (1 to process 32-bit mode and the other for 64-bit mode).

But there is an option (workaround) where you can have both the versions installed on the same machine by performing a “/quiet” install of these components from command line. To do so, download the desired AccessDatabaseEngine.exe or AccessDatabaeEngine_x64.exe to your PC, open an administrative command prompt, and provide the installation path and switch /quiet. Ex: C:\Files\AccessDatabaseEngine.exe /quiet. Please note that this approach is not recommended and haven't worked in few instances, so would request you to move to 2 different server approach if possible.

• Alternative option is to download 32-bit Microsoft Access Database Engine 2010 to install with 64-bit MS Office 2016.  Microsoft Access Database Engine 2010 Redistributable: https://www.microsoft.com/en-ca/download/details.aspx?id=13255

KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To