Microsoft Access Database Server Code
Turn your Access Database into a Database Server
Brought to you by:
vcrfix
File | Date | Author | Commit |
---|---|---|---|
html | 2019-09-27 |
![]() |
[6f8de8] Move API list to new route, fixed POST requests... |
node_modules | 2019-09-27 |
![]() |
[6f8de8] Move API list to new route, fixed POST requests... |
resources | 2019-09-09 |
![]() |
[a9d68d] fixed the uncaught exception thrown in node-ado... |
README.md | 2019-09-19 |
![]() |
[2ea52c] Added route listing to base|root route of http:... |
app.js | 2019-09-27 |
![]() |
[6f8de8] Move API list to new route, fixed POST requests... |
build.cmd | 2019-09-27 |
![]() |
[6f8de8] Move API list to new route, fixed POST requests... |
package-lock.json | 2019-09-27 |
![]() |
[6f8de8] Move API list to new route, fixed POST requests... |
package.json | 2019-09-27 |
![]() |
[6f8de8] Move API list to new route, fixed POST requests... |
settings.json | 2019-09-07 |
![]() |
[7afb41] Initial Commit |
test.accdb | 2019-09-07 |
![]() |
[7afb41] Initial Commit |
The following code will turn any accdb (Access Database) into a Database invocable via a REST API
Edit the settingsjson to specify the accdb database file
{
"domain": "localhost",
"host": "localhost",
"port": 5151,
"database": "test.accdb",
"password": "5f4dcc3b5aa765d61d8327deb882cf99"
}
From the Windows command line, requires Node/NPM to be installed (https://nodejs.org/en/download/)
> node app.js
or download the files accdb-server.exe, settings.json, and test.accdb.
Then start the standalone executable,
> accdb-server
From your web browser, open http://localhost:5151/sql?sql=select%20*%20from%20table1
the results will show in a JSON array.
To list all routes available, use
http://localhost:5151/
Install the pkg module,
> npm install -g pkg
Create the standalone executable,
> pkg -t node10-win app.js
> move app.exe accdb-server.exe