Access database to SQLite converter

Database File:

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

About

Video tutorial - How to publish MS Access Application to Web using Jam.py and SQLite3

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 (and 2019). 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.

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](please review the above video) option and download the Export 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, or it will contain only a few tables.

MS Access might have a special character, space, slash/backslash, dash (-),quote('), etc for the table field, as well as table name. The conversion will try to replace those, however, we would advise to fix the issues in MS Access, before attempting the conversion. Single quote in table rows are not replaced yet, and rows will be skipped.

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 it if conversion failed, and attempt again. The best is to inspect the Log file, sometimes clearly showing the error. If the log file is empty, something went wrong. No need to try again if Access wasn't fixed.

Timeout issue might occur with a 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 for such data, the tool can be provided on demand. Password protected database conversion might fail, no need to try again.

Terms and Conditions

"This site and its components are offered for informational purposes only; this site shall not be responsible or liable for the accuracy, usefulness or availability of any information transmitted or made available via the site, and shall not be responsible or liable for any error or omissions in that information."

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.