We have experienced the same problem here on installs involving the following Windows 10 editions so far (does not seem to be bound to Windows version):
Microsoft Windows 10 Pro 10.0.17134
Microsoft Windows 10 Pro 10.0.19041
Microsoft Windows 10 Pro 10.0.18362
Microsoft Windows 10 Pro 10.0.16299
Microsoft Windows 10 Pro 10.0.18362
And the following Office editions:
Office 2016
Office 365 16.0.13029.20344
Office 365 16.0.13127.20408
We have for many years used MapInfo in scenarios where Access Database Engine is used in parallel with Office installs (because they don't have Access or not the same bitness as MapInfo). This has worked across Office updates but something has changed.
One of our customers have needed to repair by reinstalling Access Database Engine three times since August and it just happened again yesterday to yet another. We can't keep on doing this and are working hard to figure out the underlying cause.
We're not sure it's that Access Database Engine breaks, because we have Access connectivity before this error in our application? We do however also get it as soon as we open Access tables from MapInfo.
Also we suspect Jane's issues will return in a few weeks or months as Office updates are released.
------------------------------
Jonas Nordlund
Software developer
Norconsult AB
Sweden
------------------------------
Original Message:
Sent: 08-24-2020 04:28
From: Jane Mason
Subject: MS Office update - MapInfo Pro v17.0.4.3 link to Access database no longer working
Thank you Duri. It was indeed something similar that happened - the Access database engine was re-installed and now 64bit is working again and all is well.
Thanks for your help,
Jane
------------------------------
Jane Mason
Biological Records Officer (GIS), Suffolk Biodiversity Information Service, UK
Original Message:
Sent: 08-23-2020 20:39
From: Duri Bradshaw
Subject: MS Office update - MapInfo Pro v17.0.4.3 link to Access database no longer working
Hi Jane,
My guess is that IT have installed the 32bit version of Office which has removed the 64bit Microsoft Access Database Engine which is used by MapInfo to access Excel and Access file types. You should be able to test this theory by trying to open an Excel spreadsheet.
have a look at this article for more info
https://support.pitneybowes.com/VFP06_KnowledgeWithSidebarTroubleshoot?id=kA280000000TSZiCAO
------------------------------
Duri Bradshaw
Spatial IT Consultant
Insight GIS
Original Message:
Sent: 08-20-2020 11:26
From: Jane Mason
Subject: MS Office update - MapInfo Pro v17.0.4.3 link to Access database no longer working
Our IT remotely installed a MS Office update this morning, since when a MapBasic program fails and causes MapInfo v17.0.4.3 to crash. This is where a Link Table is populated with the results of a query, and then populates a table within Access (16.0.13029.20342) 64-bit. The IND, ID and MAP parts of the MapInfo table are deleted when MapInfo crashes. I get a runtime error (Application: MapInfoPro.exe "The process was terminated due to an unhandled exception) and an application error (Faulting application MapInfoPro.exe, Faulting module name ACEDAO.DLL).
It seems that MapInfo Pro v17.0.4 can no longer connect to Access - has anyone else had this problem? I am going to have to revert to v15 to use the old Access driver in order to keep working for now.
Thanks in advance for any help,
Jane
------------------------------
Jane Mason
Biological Records Officer (GIS), Suffolk Biodiversity Information Service, UK
------------------------------