patrickcarriello/ms-access-http-server

MS Access HTTP Server (Python)

MS Access HTTP Server (Python)

Obtaining data from a Microsoft Access database using an HTTP request. Output format: JSON, CSV, HTML. You can also make requests to add, modify and update data.

HTML output example:

JSON:

Adding a record:

Usage

Run http_query.py, type URL in browser:

http://127.0.0.1:80/db_test?mime=html&headers=true&sql=SELECT TOP 3 * FROM Suppliers

Parameters:

• mime - output format (html, json or csv).
• headers - column headers.
• sql - actual query. When you generate queries in your application, don't forget to encode in URL-friendly format

Setup

Requirements: Windows 7 and above, Python 3.7 Download project, install requirements: pip install -r requirements.txt Change settings in settings.ini

Section web server - settings for the HTTP server.

• bind_ip - local IP address to which the server is bound. By default it is 127.0.0.1 so server will only respond to requests received from the same computer.
• white_list - list of IP adresses separated by commas from which connections are allowed.

Then you need to add the databases. Each database (mdb or accdb file) is a separate section with a unique name. Settings:

• db - full path to file.
• driver - ODBC driver name.
• uid - user.
• pwd - password if required.
• systemdb - .mdw file if required.

Optionally you can add test queries to be executed at startup of msaccess.py:

• test_run - SQL query for selection (SELECT).
• text_exec - SQL query for add/modify/delete (INSERT/UPDATE/DELETE).