[UtahDave]

At a previous job an operations analyst built out an Access database because our IT group never got around to helping him build something more robust. It actually worked pretty well.

Once we started getting to scaling issues we imported all the tables into MySQL and had Access use the remote tables that existed in MySQL.

This worked really well. All the forms and various things were in Access and the tables in MySQL and this scaled out pretty well to many 10s of users.

A nice side benefit is that I was able to reuse a lot of that data in an internal web application.