Unable to open TAB files linking Access or Excel files in MapInfo Pro 64-bit

Occurrence

In 64-bit MapInfo Pro, I receive an error or crash when trying to open TAB files that linked to an Access or Excel file. Or MapInfo is simply crashing when trying to open a workspace.

Note that if you save the XSLX file in Excel as a CSV or legacy 97-03 XLS format, these still open.

Solution

This is due to Microsoft not supporting side-by-side installation of Office 32bit and 64bit versions. 
There is a workaround that has been tested with Office 2013 or Office 2016 (365) installed. If you are using Office 2010, it is recommended you upgrade to a newer supported version of Office first.

In the start menu search for "Access Database Fix". Run this shortcut and click OK on the prompt to apply.

Note that this fix is not permanent, and may break when Windows Update automatically updates your Office installation. If this occurs, the fix will need to be run again from time to time.


If the issues persists, please do the following -

1. Manually uninstall all versions of the Microsoft Office Access Database Engine 2010 from the control panel.
2. Then run the Access Database Fix from the start menu>Datamine folder.


If this still persists you can try the following -

1. Manually uninstall all versions of the Microsoft Office Access Database Engine 2010 from the control panel.
2. Download the 2016 version of AccessDatabaseEngine_x64.exe from this page 
https://www.microsoft.com/en-us/download/details.aspx?id=54920
3. Open a command prompt and run as admin, and use the "cd " command to change the directory to the downloads folder
4. Run the installer with a \passive parameter -
AccessDatabaseEngine_x64.exe /passive

Note if you wish to use 32bit software you should only install the Acess 20120 engine 32bit, not the 2016 version as it will conflict.


Would you like to...

Print this page Print this page

Email this page Email this page

Post a comment Post a comment

Subscribe me

Remove Highlighting Remove Highlighting

Edit this article

User Opinions (106 votes)

99% thumbs up 0% thumbs down

How would you rate this article?




Thank you for rating this article.

Related Articles

Attachments

No attachments were found.

Last Updated on: 6th of July, 2021