Access Database Converter

An online open source Microsoft Access database converter

June 19, 2017
In category Tools

The converter needs JavaScript: it checks your browser with Cloudflare Turnstile before it takes a file. Turn JavaScript on to convert a database here.

About

This is an online Microsoft Access database conversion tool to convert old and new Access database formats to some other popular databases and formats. It runs AccessConverter, my command line tool built on Jackcess, a Java library for reading and writing MS Access databases. It takes .mdb and .accdb files from Access 97 up to 2019/2021, and Microsoft 365.

MS Access was the first database I got my hands on when I began writing code. I have some old projects using Access databases that I want to rebuild, or just get the old data to port to some other environments. I even have some clients with systems using old Access databases that sometimes is needed to be converted to process and use all the data. So, I built up this online tool to have it anytime and for everyone to use it.

Exports

It exports an SQLite database, a MySQL 8 or MariaDB dump file, and JSON. Primary keys, indexes, foreign keys and defaults come along wherever the target can enforce them. The JSON is one document: the schema first, then every table’s rows as objects, or as arrays if you prefer. SQLite and JSON outputs are read back and every value is compared with your database.

Pictures, files and OLE objects are left out unless you ask for them. You get a zip with the output and a report of the tables, rows and any warnings, with what to do about each.

Password-protected databases

If the database is encrypted, the page asks for its password after the upload, with three attempts. The password is kept only until the converter has read it, and never logged.

Limits

Up to 50 MB per upload, 1,000 tables and 10 million rows per database and 5 minutes per conversion. You can convert 5 databases an hour, one at a time.

About the data

Every upload must have a supported Access header and open in the converter, or it is rejected and deleted. Each conversion runs in its own isolated container, with no network and nothing but its own files, and nothing inside your database is ever run.

Nobody looks at your database. The uploaded file is deleted as soon as the conversion ends. The result can be downloaded only from the browser that uploaded it, and it is deleted when you press “Delete my files”, or an hour after the conversion at the latest.

Bugs

Please report any bugs or features you may want, by using the Contact Form on this blog.

Open source

I have released the source code and binaries of the Java application on Github. Version 3 is a rewrite under the Apache License 2.0; earlier versions were MIT. This tool runs 3.2.2.

Github repo: https://github.com/clytras/AccessConverter