Access database to SQLite converter

Database File:

Select MS Access database file to upload (db,mdb,accdb) (50MB max).

About

This is an online Microsoft Access database conversion tool to convert old and new Access database formats to SQLite database for now. It is built with Jackess, a Java library for reading and writing MS Access databases. It supports Access 97 and all versions 2000-2013. Depending on file size, the conversion might take a few minutes! Please wait to see: File is successfully converted! Click on here to download the file.

After the Access file is uploaded and converted with no errors, two links are presented:

- link to download the sqlite3 file and the Log file as per above (do this before anything else)

- link to access the Application Builder which is using the sqlite3 data converted from Access

The App Builder link will start builder.html and there set on Database [F4]/"DB manual mode" and Import all tables into the "Test Import" Group (click on Test Import/Import button), taking care of all needed DB fields correction or missing info. All fields must have datatype if not already recognized. Since this is Jam.py version 6, it is possible move the tables into some other Groups (button between Delete and Import), create new Group, etc.

After Importing some tables per above procedure, just replace builder.html with index.html from the link to access your data. One can even set the App password or create users within the builder.html, etc. It should be fully functional App.

It is important to note that once the Access file is converted and all tables Imported through the builder.html, it is not needed to use this service at all. Immediately use the Export [CTRL+E](broken at the moment, as on 5th of May 21) option and download the file. Than, install the Python Jam.py framework locally or on the server, create the New application, Import the same downloaded file, and point the Application to sqlite database as per creating the New application. That is all.

Notes/Issues:

This tool is for the database tables only, it does not covert MS Access file with no tables in it. Hence, no need to upload Front end application, which probably connects to SQL Server or some other database(s). Output will be empty.

MS Access might have a special character or space or slash/backslash for the table field, as well as table name. While SQLite3 is fine with this, Python Jam.py might have issues. Hence, we would advise to fix the issues in MS Access, before attempting the conversion.

The conversion will fail if there are linked tables in MS Access. Please remove any linked tables before attempting the conversion.

There might be an #Error in the Access field, please fix if conversion failed, and attempt again. The best is to inspect the Log file, sometimes clearly showing the error.

Timeout issue might occur with bigger database. CloudFlare will wait 100 seconds for a HTTP response from our server before you will see a 524 timeout error.

Please do not upload confidential, private or password protected/encrypted database, if conversion to SQLite3 is needed, the tool can be provided on demand. Password protected database conversion might fail, no need to try again.

Jam.py Team

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Any issues or questions, please post to Jam.py Users Mailing List.