3 ms·
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
by thu2111 6y ago
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.
- rvba 6y agoIMHO the biggest problem is the 2GB database size limit
- bleepblorp 6y agoLibreOffice 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.