I've recently had several questions on the prerequisite for the Microsoft Access Database Engine. I wanted to provide some background on this to help understand you might be seeing this prerequisite.
Here are screenshots depicting where you may see this error:
Management Reporter needs either Microsoft Office or the free Microsoft Access Database Engine redistributable installed for the correct architecture of the machine. This means that a 64-bit machine needs either 64-bit Office or the 64-bit version of the Access Database Engine installed. The problem that many people run into is they may have a 32-bit version of Office already installed, or some other Office component installed, which prevents installation of the 64-bit version of any other Office component.
There are two functions in Management Reporter that make use of the Office components.
So depending on your needs, even though you see the warning message that the Microsoft Access Database Engine should be installed, you may not need to install it. If you do not need to migrate your FRx reports, or have already migrated your reports then you do not need the Office components for the Migration Wizard. If you do not plan on linking to Microsoft Office Excel for including Excel data in reports, then you also do not need the Office components installed.
I'm having trouble installing the server component of MR. I have installed the Access Database Engine 64-bit redistributable but I still get a warning and the installation doesn't detect it. I'm not sure if this is the key problem though? The only other error I see in the log is "Result 'Adding SYSADMIN role to AX user 'bcp1'', status = failed: Error in getting SID"; that user already has the SYSADMIN role. In any case the databases are not created and the service is apparently not created. Any suggestions?