Access Database as a Server

The following code will turn any accdb (Access Database) into a Database invocable via a REST API

Dependencies

1. Requires Microsoft Access Database Engine 2016 Redistributable (install 32 bit version, even though you have x64 system) at https://www.microsoft.com/en-US/download/details.aspx?id=13255
2. Requies NPM and Node, if not using the standalone executable?

Starting the Database

Settings.JSON

Edit the settingsjson to specify the accdb database file

{
    "domain": "localhost",
    "host": "localhost",
    "port": 5151,
    "database": "test.accdb",
    "password": "5f4dcc3b5aa765d61d8327deb882cf99"
}

Launching server

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

Testing Server

From your web browser, open http://localhost:5151/sql?sql=select%20*%20from%20table1

the results will show in a JSON array.

List all routes

To list all routes available, use

http://localhost:5151/

API Routes

• query = used for SELECT queries
• execute = used for INSERT, UPDATE, DELETE queries
• sql = used for INSERT, UPDATE, DELETE queries (kept for backwards compatibility)
• about = information (if npm is installed, will show npm module hierarchy)

Build a standalone Win64 executable

Install the pkg module,

> npm install -g pkg

Create the standalone executable,

> pkg -t node10-win app.js 
> move app.exe accdb-server.exe