There are a few SQL differences between Access and MySQL but generally the transition is painless.
I've moved quite a few sites over to MySQL with great results.
Monaghan - my sites are all in Classic ASP at present so may be interested in talking with you about migrating to ASP.NET at some point
