I've used MyODBC with Access without problems, although not in a production situation, it works very well.

Bear in mind that if data integrity is important and/or lots of people are likely to be updating records constantly, PostgreSQL may be a better option.