Early in my IT career, I did a lot of MS Access development, and MS Access gave me a huge advantage (at the start) of the company my cofounders and I started and sold. Although it certainly had it's limitations, MS Access did meet a lot of needs for SMBs, much as how you describe FoxPro did/does.

If you want something similar with respect to ease of development and deployment, check out Oracle Application Express, or APEX, which comes with the database as a no-cost option. A good quick summary of APEX can be found here: https://insum.ca/about-apex/ (Disclaimer - I work with Insum.)

Most on HN seem to really dislike Oracle, which is not completely unwarranted. However, a framework like APEX can enable you to stand up CRUD apps very quickly, and Oracle has a free version of the database (Oracle XE, which includes APEX), that will easily meet the needs of many SMBs. I've gone through a few different "Build an X clone" type tutorials online to learn both python and JavaScript frameworks, and in each case, building the same thing with Oracle APEX takes a much less time, and is way easier given the declarative interface.

APEX is not for everyone and won't solve all your problems, but for those looking to modernize MS Access and FoxPro apps, it's worth checking out.