Thanks for the reply Ray.
I think this could potentially be a bit of a minefield.
I will ascertain how 'live' the read only web data needs to be. I am thinking that if they ran the msaccess database locally, as they do now, but with a mysql back end, they could do a data export on a daily/weekly basis for the web site.