MySQL and MSAccess on the web?

[qwkslvr1999]

I have an Access97 database which will be converted into a MySQL db. I know it is possible to convert the backend db into a MYSQL db and that the Access db frontend can be linked to the MySQL server through ODBC.

My question is, what would be the process if the db needs to be accessed from the web?

I would like to keep the front end in Access 97(which has the forms, queries and reports) and just update the backend (in MySQL) every so often.

I hope I explained my problem clear enough. thanks in advance!

 

[FoFa]

That does not really explain it because of the backend is in MySql, what is there to update since you would be doing that online with your frontend anyway? And if you add a web frontend, why keep the Access frontend (don't need 2 frontends)? To me it sounds more like you are COPYING the data from your Access DB to a MySql DB and still using the Access DB. If the data on the MySql DB is static, than you can do a repopulation with no problem. However if the data in both places can be updated, well lets just say not a good thing to try to keep them in sync. Better become an expert in replication.

 

[qwkslvr1999]

I was thinking that the MySQL database will be repopulated and just be queried by some sort of a web form. I think that it might involve a lot of work if we would try to recreate all the forms we already have in Access.

So, with that idea,would something like ASP( vbscript or jscript?) be good enough to connect and search the MySQL db?

thanks!