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

SAP Knowledge Base Article - Public

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

Symptom

  • 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

32bit.jpg

Environment

  • SAP Crystal Reports 2016
  • MS Office 2016 64 bit

Reproducing the Issue

  1. Install the 32-bit Microsoft Database Engine 2016

Cause

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

Resolution

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.

Keywords

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

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016