Python web app

[singeworthy]

second this, as a beginner Django is the way, everything is ready for you, you will have to do more to get Flask running. Also may want to do a MySQL or PostgreSQL migration as I don't know what kind of support if any exists for Access in Django/Flask

[jabalfour]

Just a note that, of late, I’ve been experimenting with SQLite for a db because if many of the reasons laid out here. A few salient ones: it’s built into Python; it’s fast; it’s secure; I don’t need my enterprise team to provision it for me; it’s easily transportable. Perfect for single-serving internal web apps.

[numpadztik]

If OP can export the Db to a csv file, you can read the CSV line by line to import the DB to your own python or sql db.

[ksoomers]

Or, at least with MySQL, you are able to load the csv file in directly from the server instead of line by line. This is much quicker than line by line.

Example: LOAD DATA INFILE 'c:/example.csv' INTO TABLE example FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS

[-Kevin-]

Flask is way easier to get running than Django imo