4 ms·

Access DB is still included in Microsoft Office

by fpoling 6y ago

OldHand2018 6y ago
Only some versions of Office, mainly the non-cheapest business versions.
zokier 6y ago
And LibreOffice has Base, a sadly often neglected component.
- II2II 6y ago
  Another issue with Base is the required JRE. Installing the JRE may be trivial, but it means that an error message is the first experience most people will have with Base. As for Access, it's access is limited due to the much higher price point of Business/Professional versions of Office. In terms of office suites, that version is about two to three times more expensive than an equivalent office suite from the mid-1990's (adjusted to 2021 dollars). In other words, people will only have Access if they feel that the additional cost is justified. That additional cost may be fine for business use, yet it also means that people have less exposure to databases to start with. With respect to exposure, there also appears to be an absence of general purpose databases for home users these days. (By that I mean in terms of cost and ease of use.)
  - zokier 6y ago
    > Another issue with Base is the required JRE I thought that they dropped JRE requirement when the engine was switched to Firebird? Googling around apparently the transition wasn't quite successful :( https://ask.libreoffice.org/en/question/279711/firebird-dead/ https://ask.libreoffice.org/en/question/279711/firebird-dead...
    - II2II 6y ago
      The only "embedded database" option (HSQLDB) requires the JRE. I don't know if this holds true for the "connect to an existing database" options, but I would rather throw together a Python script using SQLite when it reaches that level of complication. (It uses my existing knowledge.)
      - zokier 6y ago
        > The only "embedded database" option (HSQLDB) requires the JRE Firebase is still available as an experimental option as another embedded database, just confirmed on my installation. Also while I was at it, tested it with Java disabled and HSQLDB predictably did not work, but Firebird did continue to work. Apparently it also opens an pre-existing Firebase odb file even without experimental flag being on. https://ibb.co/jM6k07w https://ibb.co/jM6k07w

Access DB is still included in Microsoft Office

OldHand2018 6y ago

Only some versions of Office, mainly the non-cheapest business versions.

zokier 6y ago

And LibreOffice has Base, a sadly often neglected component.

II2II 6y ago
Another issue with Base is the required JRE. Installing the JRE may be trivial, but it means that an error message is the first experience most people will have with Base. As for Access, it's access is limited due to the much higher price point of Business/Professional versions of Office. In terms of office suites, that version is about two to three times more expensive than an equivalent office suite from the mid-1990's (adjusted to 2021 dollars). In other words, people will only have Access if they feel that the additional cost is justified. That additional cost may be fine for business use, yet it also means that people have less exposure to databases to start with. With respect to exposure, there also appears to be an absence of general purpose databases for home users these days. (By that I mean in terms of cost and ease of use.)
- zokier 6y ago
  > Another issue with Base is the required JRE I thought that they dropped JRE requirement when the engine was switched to Firebird? Googling around apparently the transition wasn't quite successful :( https://ask.libreoffice.org/en/question/279711/firebird-dead/ https://ask.libreoffice.org/en/question/279711/firebird-dead...
  - II2II 6y ago
    The only "embedded database" option (HSQLDB) requires the JRE. I don't know if this holds true for the "connect to an existing database" options, but I would rather throw together a Python script using SQLite when it reaches that level of complication. (It uses my existing knowledge.)
    - zokier 6y ago
      > The only "embedded database" option (HSQLDB) requires the JRE Firebase is still available as an experimental option as another embedded database, just confirmed on my installation. Also while I was at it, tested it with Java disabled and HSQLDB predictably did not work, but Firebird did continue to work. Apparently it also opens an pre-existing Firebase odb file even without experimental flag being on. https://ibb.co/jM6k07w https://ibb.co/jM6k07w