Re:Missing Covid-19 test data was caused by the ill-thought-...
by bleepblorp on Monday October 05, 2020 @02:55PM
(#24690778)
LibreOffice Base is something of an attempt at a newer Access, but unfortunately it's far from ready for production use.
Base has very solid data storage foundations (including the ability to connect to real database servers) but the UI is very buggy and is painful to fight with. Note I said 'fight with' rather than 'use.'
Base seems to have a fair bit of potential, however, if someone where to pour some money and/or time into developing it further.
Weaknesses of Access in no particular order: very poor multi-user/multi-device-access features. No real concept of servers. Buggy, had a nasty habit of corrupting its custom file format causing data loss (Excel never does this). Does expect you to understand SQL, data normalisation, etc. VBA just about serviceable for a spreadsheet but not good enough for a 'real' database-backed app.
Probably someone could try and make a better Access. There are surely lots of startups doing that already, along with hosting. All the "no code" tools that are out there, etc. Access had the advantage of coming with Office so lots of people had it already, whereas today's subscription based services that host your data have incremental cost.