For version 12.0 you need to install MDAC 2010 from here. This has to be done on the server where you publish your application. You need to install the x86 version if the target machine is 32 bit or the x64 version if the target machine is 64 bit and your application is built with … Read more
Slightly different but node-adodb worked well for me for .accdb files: https://www.npmjs.org/package/node-adodb // Get the adodb module var ADODB = require(‘node-adodb’); ADODB.debug = true; // Connect to the MS Access DB var connection = ADODB.open(‘Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\dbs\\my-access-db.accdb;Persist Security Info=False;’); // Query the DB connection .query(‘SELECT * FROM [TestTable];’) .on(‘done’, function (data){ console.log(‘Result:’.green.bold, data); })