I write Access 97 multi-user programs for a living. In my opinion...
1. FMP layouts look much better and its easier to construct printed forms/reports in FMP.
2. Access allows you to construct complicated queries and save these queries. Also, open forms and reports from these queries.
3. I find it easier to pass values or parameters through-out an access program. I.E. tracking the user Employee ID Number through-out the program. Probably doable in FMP but its really easy in Access.
4. I think Access is faster. Sorts and Queries on indexed fields are very fast. Sorts are not as fast in FMP.
5. Multi-user DBs are possible in Access by putting the tables on the server and the forms, queries, reports, macros, etc. in a separate db.
6. A workable Access DB takes much longer to build and requires a steeper learning curve up front. Visual Basic takes much longer to learn.
7. Access objects have many properties which can be changed in Visual Basic as the program is running.
8. FMP is more fun, much easier, and just looks better to the user.
Just my opinion.
Mike