try any of the SQL toolsets such as HeidiSQL or even MySQL's Workbench
also see if you cna use PHPMyAdmin on your db server (if its your own local db then no problem, if its a remote server you may be limited as to what tools you can use.
virtually anything can talk to MySQL including Access. but for a web front end then PHP, Ruby, Python and others are worth a look
aside form using Access there is nothing out there that Im aware of that matches Access QBE. but then I'd argue you'd be better off ditching Access and fully embrace the SQL world
http://i792.photobucket.com/albums/y.../miniDGR-0.jpg I've taken part in the Distinguished Gentlemans ride, and although I enjoyed the day the main focus was to raise awareness of Prostrate Cancer and raise some funds for research. Many thanks to the many sponsors who helped me raise some £360 towards this cause, its much appreciated and rather humbling.
Thanks for the suggestions, I will have a look at those.
I have given a bit more thought about exactly what I am looking for (in addition to managing the DB with one of your suggested systems).
I want to be able to build web based forms that have a partially built query (specific tables / fields and records), users should be able to enter certain criteria.
Eg Allow a user to search for a country name eg GB
Then perform an update on all those records found to UK
Or to search all records where userID = user1
Then edit specific fields in each record found.
And with some forms, allow a user to export all records found as an excel or CSV file.
Basically - the sort of things that could be done with a MS Access form, built on a query - but web based.
I realise I could have specific pages / forms built in PHP to do these tasks, but would like to be able to use some application which will allow me to build the pages / forms quickly when I require them.
I think what I need is a query builder. I am currently looking at these, but perhaps someone could direct me to a suitable one.