Problem with Access in FME after Office365 migration

Anyone any advice? I'm a bit out of ideas here on how to solve this..

Posting the solution found in case it may help another user with the same issue. If you are using Office365 and is running into the same error, please go to the following link:

https://www.microsoft.com/en-us/download/details.aspx?id=39358

Download and install the appropriate bit-version of Access 2013 runtime installation package (the bit-version should match your FME installation).

At the time of this comment, Microsoft has not released an installation package for Access 2016 runtime that is compatible with Office 365. According to this Microsoft forum thread, Access 2013 runtime installation is functionally equivalent and should resolve the error.

Edit: this driver may also work but has not been tested https://www.microsoft.com/en-ca/download/details.aspx?id=54920

Hope this helps,

Debbi

The second link (id=54920 2016 runtime) did not work for me but the first link (id=39358 2013 runtime) does work. I am using FME 2019.2 32 bit with Office 365 32 bit.

Installing the 2016 Access Runtime solved the problem of this warning polluting our logfiles with extra noise. (FME would try Microsoft.ACE.OLEDB.16.0 then fallback to Microsoft.ACE.OLEDB.15 and then to… until it finally found a version number that worked. )

I thought there was an idea somewhere about adding a parameter to the reader select the version number to start with but I’m not finding it today, so adding this note here so it’s found the next time we search for this message there’s something to follow. ; -)