Management Reporter - Unable to install 64 bit version of access database engine.

In installing Management Reporter Server you are unable to proceed with the install if you have Office 32 bit version installed.


Error: You cannot install the 32-bit version of Microsoft access database engine is installed. however the 64-bit version must be installed to generate reports with Microsoft excel data


To overcome the issue, this is, being able to install 64-bit Microsoft Access Database Engine redistributable, side by side with a 32-bit Microsoft Office installation, you must install the redistributable package in passive mode.

You will need to open the Command prompt (Start | Run | CMD) and change the path to the directory where the redistributable package was downloaded.

To change the command prompt to look at your downloads folder type the following:

cd C:\Users\username\Downloads\

Then type the following:
C:\Users\username\Downloads>AccessDatabaseEngine_x64.exe /passive
press enter

You should now be able to complete your install.