All those stories are 100% true. And when someone did end up hosting an Oracle based SQL database, they’d pull from it in Access and it’d take several hours for one query. My R code did the same in about 10 seconds.
Access has its uses, need a database to catalog your (parents) physical photo albums, or perhaps you want to have a database for recipies at home to make them easier to find, then in those cases Access should be fine if you are willing to maintain it.
I specifically avoided mentioning Access as I have hear horror stories about it when it goes too far.
All those stories are 100% true. And when someone did end up hosting an Oracle based SQL database, they’d pull from it in Access and it’d take several hours for one query. My R code did the same in about 10 seconds.
It’s not good software. Lol
Access has its uses, need a database to catalog your (parents) physical photo albums, or perhaps you want to have a database for recipies at home to make them easier to find, then in those cases Access should be fine if you are willing to maintain it.