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.
Isn’t that part of the same office package or does that cost more?
Not sure about the current state of things since I haven’t used MS Office in decades, and I believe it’s entirely made of web apps now, but Access definitely used to be extra. As in, there always were at least two editions of Office, one that included Access and one that didn’t. And the former was significantly more expensive.
Technically even Access would make more sense. Isn’t that part of the same office package or does that cost more?
Granted, SQL is still better but I’ve worked in government where you’re lucky to be using digital sheets at all.
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.
Reminding me of corrupted .mdb files means I need more alcohol tonight to pacify the demons in my head
Not sure about the current state of things since I haven’t used MS Office in decades, and I believe it’s entirely made of web apps now, but Access definitely used to be extra. As in, there always were at least two editions of Office, one that included Access and one that didn’t. And the former was significantly more expensive.