About:
This is an online Microsoft Access database conversion tool to convert old and new Access database formats to SQLite database for now. It supports Access 97 and all versions 2000-2013-2019.
If you have found uploading your data unsafe for any reason, please consider this...
and after donating, the tool and instructions will be emailed to you for offline migration. The 5x2Gb file was migrated in a similar way. Totally safe.Depending on file size, the conversion might take a few moments!
After the Access file is converted with no errors, proceed with below for making the Web application. Or just use created SQLite3 file.
Please review the Migration Tips first and/or review the below "Lending Library" migration video, which is using migrated Access file. Install the Python Jam.py framework locally or on the server, create the New application, and fill the necessary info. Set the Application Builder to "DB manual mode". This means your new database is safe from changing the structure, like incidentally deleting the table or similar. Create your own Group Item, ie "My testing", or "Inventory", etc.Jam.py will create a dropdown menu if there is more than one "Group Item" with the tables in it. Import all tables into the created Group Item.
Click on Import button, taking care of all needed DB fields correction or missing info.
All fields must have a datatype if not already recognised. The "DB field name" should not be touched, the "Caption" is normally MS Access field caption, and the "Name" must be valid JavaScript naming standard, in short, no spaces, special characters, etc. To help you with the process, here are some videos:
Access Lending Library template migration video - 3 minutes video applicable for offline migration
Access Personal Ledger template migration video - 5 minutes migration video applicable only as an reference
Video tutorial - Simple CRM built automatically with Selenium IDE in 2.45minutes, demonstrates the Tutorial. Part 1. First project
New style Demo - New style CSS Demo Application
Access Personal Ledger template migrated application - Migrated Personal Account Ledger
Access Northwind Traders template migrated application - Migrated Northwind Traders
Notes/Issues:
This tool is for the database tables only, it does not convert MS Access file with no tables in it. Hence, no need to upload a 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. The ODBC linked tables are supported.
The process is expecting that the Primary Key exists on all tables. The simple INTEGER is not a Primary Key. The Log File will indicate this. Please address and fix this issue before attempting the conversion. Only Use One Numeric Field as the Primary Key, ie. AutoNumber field.
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.
The conversion will fail if there are linked tables in MS Access. Please remove any linked tables before attempting the conversion.
The conversion will fail if Access is using utf-16-li, no need to try again. No log or link will be produced and we suggest fixing Access.
There might be an #Error in the Access field, please fix it if conversion fails, 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.
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 Contact Form or for public comments post below.
Comments: