VERIFIED SOLUTION i

How to resolve Access related errors for users having both MapInfo Pro 32-bit and 64-bit on a PC with Microsoft Office 64-bit installed

Products affected: MapInfo Pro™
Resolution on how to successfully Open Excel & Access files via Office 365 or Office 2013 64 bit with both 32-bit & 64-bit versions of Professional on the same machine.

For users with Office 365 64-bit or 2013 64-bit installed:

If the MapInfo Pro Release notes workaround on Page 3 has already been applied and opening Excel/Access type files are still crashing MapInfo Professional 32-bit or 64-bit, please try the following:

1. Uninstall both Microsoft Access database engine 2010 drivers via Control Panel\All Control Panel Items\Programs and Features.

2. Download Microsoft Access Runtime 2013 64-bit only here (AccessRuntime_x64_en-us.exe) and then Install the 64-bit Access Runtime 2013 64-bit driver by right-clicking on the file in Windows Explorer and choosing "Run as Administrator".

3. Download the MS Access Database Engine 2010 32-bit from the following Microsoft link.  
The 32-bit version is named AccessDatabaseEngine.exe.  (Do not run the setup from Windows Explorer) 

4. Make sure to note the location of the download for the AccessDatabaseEngine.exe file.
In Windows Explorer, navigate to the System folder (for example C:\Windows\System32), right-click on cmd.exe
and select "Run as Administrator".

5. At the command prompt, navigate to the folder where the 32-bit Office 2010 driver is located. For example, if  AccessDatabaseEngine.exe was downloaded to C:\Temp, then type cd C:\Temp in the command prompt, and click Enter.

6. Type the command AccessDatabaseEngine.exe /passive and click Enter.

7. If 32-bit Microsoft Office 2007, 2010 or 2013 is installed on the system, open the registry editor 
(search for regedit at using Windows Search dialog and click Enter) and navigate to this key:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Common\FilesPaths.

If there is a registry value called mso.dll present, then delete or rename the entry in the registry. If the mso.dll registry value is not deleted or renamed, a "reconfiguring message" will be occur every time an Office application is run.

The 32-bit and 64-bit drivers are now installed on the system.
Clients can now successfully open Access/Excel files in 32-bit and 64-bit MapInfo Pro.

For users with Office 2010 64-bit:

For users with Office 2010 64-bit installed with MapInfo Pro 32-bit and MapInfo Pro 64-bit installed, follow the instructions above but note the drivers:
1) uninstall currently installed Access driver
2)  download and install the Access 2013 64-bit driver by right-clicking and choosing "run as admin":
3)  download and install the Access 2007 32-bit driver from an Admin-level Command prompt, using the "/passive" switch as described above.
4)  use Regedit to remove registry entries for the "mso.dll", as described above.



 
UPDATED:  September 12, 2019