I currently have a database in MS Access at work. The db has a fair amount of VBA code behind it.

My question is: what combination of front end etc, with mySql would be the best replacement to re-write our db in?

I'm looking for a good front-end as well as something to replace the VBA code. Thanks.

The most immediate problem that you are going to have moving off of MSAccess to mySql is providing data access to your users, who are presumably using MSWin.

The solution I chose was to provide an equivalent Web interface (using Perl CGI scripts, but you could go with PHP, or Python, or Zope, or many other possibilities) for the MSAccess user interface. With the user interface taken care of in a database agnostic fashion, I was free to move the data to my database of choice.

If the burden of installing new SW on your user's desktops is not an issue, then you should checkout the Rekall product from theKompany (http://www.thekompany.com/products/)