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!).
Are you going to run the website in 32 bit mode, if you are you can keep running with the access db as it is still supported that way in windows 2008. You can have a 64 bit machine and run a web application in 32 bit mode.
Long term you probably want to rewrite the website moving away from Classic asp to either PHP, or Asp.net.
I am assuming the database is for read-only access, and all requests can be cached. SQLite [sqlite.org] might be a worth while cross platform back-end for this purpose. So you will only need to write an app that copies the data out of the access database into the sql lite db.
Interesting about 32bit - not yet sure but I'll look into that.
Long term I wish I'd never been persuaded to use ASP in the first palce! :(
I have several web sites with a common "library" of code shared between them so reworking to another language is a very long-term solution. I recently spent some time trying to find and run a couple of asp to php converters in an attempt to move to linux: total rubbish; I may just as well rewrite from scratch. :(
The mdb's can be written to by the web apps - at least, some can; although the specific one under discussion is a read-only. On the other hand it can be sorted and extracted from in a variety of ways.
If I'm going to use any database other than Access it will be MySQL - I have experience with it and facilities available under linux and windows, including ASP read/write. It is also used for some of the other web sites. Thanks for the suggestion, though.