Using Access database on Mac Excel 2011 for Mac can execute SQL queries against Microsoft Access databases using Microsoft Query (comes with Microsoft Office) or a PivotTable, both of which require using ODBC.
I would like to open a *.mdb file (Access Database) for read only (need a SQL access, not just open the file). The main issue is that I need to open it in a NodeJS server, that runs on Mac OS X. I want to avoid installing any 3rd-party binaries and/or Microsoft Access Driver on the server - only use a node package or similar.
My server is a Meteor server, so any NodeJS (npm) will be great.
- Access database viewer free download - SysTools Access Database Viewer, Database Viewer for MS Access Lite, Database Viewer, and many more programs. Best Video Software for the Mac How To Run.
- MDB Viewer Plus is a bare-bones database application. It allows you to view, edit, and search through a Microsoft Access database file without having Access installed on the machine.
It is possible?
Thanks!
Dotan SimhaDotan Simha1 Answer
It may be extremely late, but if you're still looking for an answer (rare chances), you might want to take a look at this: https://www.npmjs.com/package/node-adodb
It's an npm package that is written in javascript. No 3rd party is needed and you barely need the 2 dependecies (used for better console display of errors).
As far as I know, it works on Windows. Not sure about MAC OS but, if you ever try it, tell me if it worked.
Keep in mind that the method .query is used for reading from the database and the method .execute is used to write in the database (not so easy to see since the documentation is written in Chineese. Took me 5 days to figure it out)
Open Access Database On Mac
