have one and only one answer: Dump Access.
A decent desk-top SQL-based GUI-oriented database is a good and useful idea. The problem is that Microsoft does not want to fix and improve Access because it would cut into SQL-Server sales. This is what happens when your only competition is yourself.