• stoy@lemmy.zip
    link
    fedilink
    arrow-up
    11
    ·
    11 months ago

    I specifically avoided mentioning Access as I have hear horror stories about it when it goes too far.

    • taiyang@lemmy.world
      link
      fedilink
      arrow-up
      6
      ·
      11 months ago

      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

      • stoy@lemmy.zip
        link
        fedilink
        arrow-up
        3
        ·
        11 months ago

        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.

    • not_again@lemmy.world
      link
      fedilink
      arrow-up
      1
      ·
      11 months ago

      Reminding me of corrupted .mdb files means I need more alcohol tonight to pacify the demons in my head