|Something a bit more Advanced: Using Microsoft Excel and Access data when running both the 32 and 64 bit versions of MapInfo Pro |
| ||There is a potential issue related to using data from Microsoft Excel or Microsoft Access when both the 32 bit MapInfo Pro v15.0 is installed alongside version 15.2 (the latest 64 bit version). These two different versions of MapInfo Pro require different versions of the Microsoft Access Database Engine. |
This is a link to a Microsoft article with related info on this topic: Click here.
Pitney Bowes advises our customers to run the Access Database Engines passively in order to open Excel files on both the 32 bit and 64 bit versions of MapInfo Pro.
Please note that this information also pertains to working with the bundle installations of MapInfo Discover.
Microsoft Access Database workaround for users having both the MapInfo Pro 32-bit and 64-bit versions on the same machine
The release notes included with MapInfo Pro v15.2 (available here) provides the necessary details.
The screen shot below shows an example of what the Control Panel might look like with both Access database engines installed. MapInfo Pro v15.0 and the 64 bit Discover bundle are also installed.
Still experiencing problems?
Even when following the passive install procedure, some clients are still known to experience issues in the 32 bit MapInfo Pro when opening Excel or Access 2013 files. If you are in this situation, here is an additional technique you can try.
Please email Technical Support if you are experiencing trouble with this specific or similar issue (firstname.lastname@example.org)
- Uninstall both Microsoft Access database engine 2010 drivers in Control Panel\All Control Panel Items\Programs and Features.
- Download Microsoft Access Runtime 2013 32 bit only here (AccessRuntime_x86_en-us.exe) and then Install the 32-bit Access Runtime 2013 32 bit driver.
- Download the MS Access Database Engine 2010 64 bit Only from the following Microsoft link.
The 64-bit version is AccessDatabaseEngine_x64.exe. (DO NOT RUN THE SETUP from Windows Explorer)
- Make sure to note the location of the download for the AccessDatabaseEngine_x64.exe file. In the System folder (for example C:\Windows\System32), right-click on cmd.exe and select "Run as Administrator".
- At the command prompt navigate to the folder where the 64-bit Office 2010 driver is located. For example, if you download the AccessDatabaseEngine_x64.exe and place it into the C:\Temp folder, then type cd C:\Temp in the command prompt, and hit Enter.
- Type the command AccessDatabaseEngine_x64.exe /passive and hit the Enter key.
- If you have 32-bit Microsoft Office 2007, 2010 or 2013 installed on your system, open the registry editor (type: regedit at Search dialog and hit the Enter key) and navigate to this key:
If there is a registry value called mso.dll, then delete or rename it. If you do not delete or rename the mso.dll registry value, you could get a Reconfiguring message every time you open up an Office application. Both the 32-bit and 64-bit drivers are now installed on your system.
- Clients can now successfully open Access/Excel 2013 files in 32 bit and 64 bit MI Professional.
Article by Matthew Wilming – Encom Discover Lead – Software Support Analyst
When not writing articles for the MapInfo Pro journal, Matt enjoys finding solutions for clients using Pitney Bowes software as well as creating a quality client experience.