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.
Comments
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.