Workaround for ‘The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine’ error.
If you get the error ‘The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine’ when trying to run the OLAP statistics, this usually means your system does not have the one or more of the data connectivity libraries for Microsoft Office (Microsoft 365 Access Runtime).
This can be easily fix by downloading from the Microsoft Download Center site. You may need to choose the correct the setup version (32-bit or 64-bit) based on the bit-ness of your Microsoft Outlook.
NOTE:
If you are not sure which bit of Office/Outlook Apps you have, refer to this KB article on how to find out – How can I know if my Outlook is 32-bit or 64-bit? – AssistMyTeam