Sudden Microsoft Access reporting: “make sure this is a valid datasource”


As of September 2020 some customers are reporting, from a project that used to work smoothly:

Opening table ....
from data source "DRIVER={Microsoft Access Driver (*.mdb, *.accdb ....
make sure this is a valid datasource.


Using the ODBC data sources (64 bit) app, try to create a system dsn to the Microsoft Access database file. When the error message:

The setup routines for the Microsoft Access Driver (*.mdb, *.accdb) ODBC driver could not be loaded due to system error code 1114:
A dynamic link library (DLL) initialization routine failed.
(C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\Office16\ACEODBC.DLL).

appears, this indicates an installation error.


The following tip from stackoverflow may help:

Settings -> Add/Remove Programs-> Select “Microsoft Access database engine” and select Modify.