The downside, of course, is that you need to learn a new software system. I believe it is worth it. It is quite different. There is an object-oriented architecture that allows for the development of sophisticated user interfaces. Database capabilities have also improved considerably with the addition of validation checks attached to the fields and records of the database.
Access is a very reasonable database system.
FoxPro should have more of these features. FoxPro buffering capabilities allow for storage in an intermediate buffered area. FoxPro has a true object-oriented architecture and Access does not. The object-oriented architecture can be used to embed error handling logic and consistency checking. It is very difficult to do this in an elegant way in Access.