I have a Perl script which used this connection string to write to an MS Access DB. It worked for Microsoft 365:
$dbh = DBI->connect("dbi:ODBC:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=$cwd/imperial.accdb", '', '');
That no longer works with Professional Plus 2019. Anyone know what I should use instead?
The short issue and story is simply that with Access 2019 (and 2016) CTR (click to run - which is most installations,then installing Access does not expose a registered copy of ACE).
[...]
So, you need to install the ACE data engine (not access). Installing ACE from here should do the trick: https://www.microsoft.com/en-us/download/details.aspx?id=54920