1) There was a startup a few years back similar to airtable that was acquhired. They had made sizeable inroads to covering the Access footprint. It probably should be a team effort like Airtable though.
It's hard to imagine one person replacing 20+ years of dev effort.
2) Excel and Access prove the need for software in a business and model out use cases.
If Access could render to the web, (similar to lotus notes to domino) that likely would be sufficient. Since most of the access backend is available, maybe that is feasible on some level.
I wouldn't argue if anyone said access wasn't designed to do those things. Microsoft always has the next solution you should move to.
I have seen Access app developers run their access app on top of a MS Sql server to bring that kind of functionality in, though.
Access was less of a database and more "let's work with our data using forms and reports".
It was powerful in the hands of people who understood the data and details they work with day in and day out and let them form solutions for themselves when there was no other way.
In many enterprises access is just there like excel, but custom software is not permitted.
Can’t resist I should thou, access is in my mind an embedded dB that added some features sits closer to SQLite than MySQL. Out of interest why do people choose to use access than SQL express is it the GUI driven development?
