• ZC3rr0r@lemmy.ca
    link
    fedilink
    arrow-up
    14
    ·
    edit-2
    2 years ago

    Microsoft spent years and years trying to get people to not use Excel as a database, until they eventually had to give up hope that anyone who doesn’t know the difference would voluntarily use Access, so they started adding database-like functionality to Excel to meet their customer’s demands and try to make the experience at least a little bit less painful.

    This is a real-life case of “meet the user where they are” despite the designer’s wishes, because even within Microsoft, there is strong agreement on not using Excel as a DB.

      • ZC3rr0r@lemmy.ca
        link
        fedilink
        arrow-up
        4
        ·
        2 years ago

        Well, to be fair to Access, it’s not like Excel is such a great multi-user database either, now is it? ;-)

        • supercriticalcheese@feddit.it
          link
          fedilink
          arrow-up
          4
          ·
          2 years ago

          Well excel nowadays doesn’t have issues with concurrent users if you have office 365 like many companies do.

          At that time it was Access with the files located at a company shared drive, the issue was concurrent writes I believe.

          • ZC3rr0r@lemmy.ca
            link
            fedilink
            arrow-up
            2
            ·
            2 years ago

            Yes, but at the time Excel didn’t support concurrency either ;-)

            Anyway, you are correct about the issue with concurrent writes, but that’s only because Access was intended as a single user DB. If you wanted a multi-user DB you should be getting MS SQL server.

            Not saying this product strategy worked (it clearly didn’t, otherwise people would not be using Excel), but that’s how they envisioned it to work.

          • filcuk@lemmy.zip
            link
            fedilink
            arrow-up
            1
            ·
            2 years ago

            Better yet, put your access backend to OneDrive to acquire an un-openable, un-deletable file.

            • ZC3rr0r@lemmy.ca
              link
              fedilink
              arrow-up
              3
              ·
              2 years ago

              I actually ran this setup for a pretty long while without major issues. YMMV but OneDrive is not a terrible way to store a single user database backend if you don’t have a lot of sequential writes going into it in a short timespan.

  • socsa@lemmy.ml
    link
    fedilink
    arrow-up
    10
    ·
    2 years ago

    Last panel is wrong. Genie would just grant him an MBA from a top tier school

    • ChickenLadyLovesLife@lemmy.world
      link
      fedilink
      English
      arrow-up
      0
      ·
      2 years ago

      I once looked through a textbook from my friend’s MBA course. The first thing I noticed was in a highlighted box in the chapter on business negotiating: “Your skill at negotiating will affect the outcome of the negotiations.”

      These are the people that make 10X what I make.

    • SpaceCowboy@lemmy.ca
      link
      fedilink
      arrow-up
      2
      ·
      2 years ago

      I mean it’s a simple file format so it’ll perform better because it doesn’t have to decode any complex formats or protocols.

      Big O? Never heard of it!

    • bagfatnick@kulupu.duckdns.org
      link
      fedilink
      arrow-up
      1
      ·
      2 years ago

      I feel you. Working in healthcare, ms office is the only thing consistently installed site wide I can take advantage of to run a db.

      • qaz@lemmy.world
        link
        fedilink
        arrow-up
        4
        ·
        2 years ago

        Couldn’t you use Access instead of Excel or is that not possible for your use case?

        • bagfatnick@kulupu.duckdns.org
          link
          fedilink
          arrow-up
          2
          ·
          2 years ago

          Unfortunately IT blocked Access installs because some staff were using it for mission critical processes, and upon leaving IT were required to maintain them. They felt excel was less likely to lead to scenarios like this.

          Little did they know excel projects are probably worse to maintain.

  • Max_Power@feddit.de
    link
    fedilink
    English
    arrow-up
    2
    arrow-down
    1
    ·
    edit-2
    2 years ago

    My 5th rule would be “no ‘fix my IT problem without me telling you what the error message says’”. Because fuck that