Codewalkers.com has a nice article posted in which they compare MS access with MySQL.
At a glance, it seems to be good article with repect to both databases. They also explain how to migrate from Access to mysql using a third party utility.

The article:
codewalkers.com – Access vs MySQL