Got it to work with 32-bit Office. However, this is against Microsoft’s recommendation not to install the 64-bit version of Microsoft Access Database Engine 2016 Redistributable with any 32-bit Office products installed.
1) From Microsoft, download the 64-bit version of the Microsoft Access Database Engine 2016 Redistributable. This will be the AccessDatabaseEngine_X64.exe file.
2) Since you have the 32-bit version of Office installed you will need to install the file using the quiet mode otherwise the 64-bit version will not install and fails with a warning.
3) Open an administrative CMD window in the folder that has the file you downloaded. You may need IT to install this for you, if you are in an enterprise environment.
4) Type "AccessDatabaseEngine_X64.exe /quiet". This will install the 64-bit version of Microsoft Access Database Engine 2016 Redistributable even though you have the 32-version of Office.
5) You should now see the MS Office 12.0 and 16.0 Access Database Engine OLE providers listed. I did not need to do a restart.
It is my understanding that ArcGIS Pro requires the 64-bit Microsoft Access Database Engine 2016 Redistributable be installed as it is a 64-bit application even when running a 32-bit version of office. I now have both the 32-bit and 64-bit version of the Microsoft Access Database Engine 2016 Redistributable installed and no issues yet.