News for hackers. Stuff that matters.
Re:Missing Covid-19 test data was caused by the ill-thought-... by chii on Monday October 05, 2020 @05:43AM (#24686059)
I'm surprised that MS Access didn't take this kind of niche.

I know it's a pretty shitty program to use - excel is much more user friendly. If MS had made excel, but have all the features of access in it...

Re:Missing Covid-19 test data was caused by the ill-thought-... by Closi on Monday October 05, 2020 @07:09AM (#24686528)
It depends which bits of functionality you want, but I think you are close to describing PowerQuery (Get & Transform) which is in Excel, which can ingest multiple data sources into effectively a relational database with hard datatypes and data-cleaning.

In PowerQuery & PowerPivot there are also no practical limits on the number of rows of data you can have (other than the impact on processing time, clearly hundreds of millions of records might start to be a problem). It's not quite access - it doesn't actually persist/store the data, just aggregates it from other sources which is probably what is required here.

Access is a little legacy and would have it's own issues. I think in reality it depends on how you are ingesting data (which is probably hospitals submitting excel templates or similar?). Maybe these could be automatically aggregated and put onto an analytics platform? (e.g. PowerBi). Hospitals could maybe report it on a portal, but I'm not convinced that the leadership would have wanted to change the established process (because of operational focus, change reduction & risk).

Re:Missing Covid-19 test data was caused by the ill-thought-... by thu2111 on Monday October 05, 2020 @11:27AM (#24688587)
For a very long time, it did.

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.

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.

Re:Missing Covid-19 test data was caused by the ill-thought-... by rvba on Monday October 05, 2020 @02:10PM (#24690328)
IMHO the biggest problem is the 2GB database size limit