Due to the MS expiries on XP and 2003 I have to upgrade to a new Windows server, probably 2008, maybe 2012, running ASP Classic (NOT .NET).
Most of the sites on the 2003 server run Access 2000 databases (currently constrained to that due to offline development hardware/software). A few sites use MySQL.
I can probably find a way to update to whatever Access version the new server runs (or convert to MySQL) since it's a one-off conversion that will remain online but one db is regenerated monthly by a client who will still be running Access 2000 on XP (not an internet-facing machine!). That db is uploaded to the web site per generation.
I'm trying to find a "simple" way to convert from Access 2000 mdb to whatever the new one is whenever the database is regenerated. Since there is no actual Access front-end on the web server (just Jet) I'm probably going to have to do the conversion locally and then upload it: tricky because I only have a Windows 2000 server here (off-line) plus several linux machines.
Options so far considered:
1. Export locally to CSV and import online, probably via a custom ASP script (the database is not large but has a couple of tables). This method would also allow me to use MySQL instead of Jet.
2. Find a Libre Base ODBC (or other) driver compatible with ASP Classic, convert locally from Access to Libre using CSV and then upload (probably not possible - haven't found a suitable driver yet!).
3. Retire from business!
Any other suggestions or solutions, please?