Access Database Engine Redistributable Command Line Install

Microsoft Dynamics GPIn the last post I discussed installing the correct version of the Access Database Engine Redistributable. One further point to remember is that the x64 distributable cannot be installed in the normal way if the x86 version of Microsoft Office is installed.

However, it can be installed using the command line. This is not a post I can take credit for (I’m posting to help me remember for future reference) as it was first covered by the Dynamics GP Blogster (AKA Mariano Gomez) over twelve months ago.

To installed the x64 Access Database Engine Redistributable via the command line, open a command prompt and navigate to the location of the installer and type the following:

AccessDatabaseEngine_x64.exe /quiet

If you’re installing the x86 by the command line, just omit the _x64.

Access Database Engine Redistributable for FRx Migration Wizard

Microsoft Dynamics GPIf you intend to use the FRx Migration Wizard when upgrading a client to Management Reporter then you need to have the Access Database Engine Redistributable installed on the same machine as the Migration Wizard.

And more than just having it installed, you need to have the correct version installed because in either case you will receive the following error:

Management Reporter - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.Management Reporter – The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.

The important item to remember is that there are two versions of the redistributable; x86 and x64. The version required is the one which matches the operating system. So for example, an x64 OS with x86 Office, needs the x64 version installed.