3 ms·
Yeah - people basically had entire applications written in Access - think very simple point-of-sale systems, record keeping tools etc. The downside of course, i
by umeshunni 2y ago
Yeah - people basically had entire applications written in Access - think very simple point-of-sale systems, record keeping tools etc. The downside of course, is that, it ran on a single computer and there wasn't a concept of multi-user systems (or maybe there was and I just wasn't aware of it).
In some ways, it's a hark back to the day of a really 'thick' client that was a server, middleware and client all in one.
- gmueckl 2y agoAccess scales from being a one process all-in-one solution to multiple processes sharing the same database file and also to a separate ODBC-connected database engine with Access as a frontend. At least some 20 years ago, there was an assistant to automatically migrate an Access database to a split Access/SQL Server setup. Looks like there are some additional configurations that MS actively supports: https://support.microsoft.com/en-us/office/ways-to-share-an-access-desktop-database-03822632-da43-4d8f-ba2a-68da245a0446 https://support.microsoft.com/en-us/office/ways-to-share-an-... If I had to throw together a reasonably robust data entry form in a time crunch today and could connect to the DB engine via ODBC, I'd probably still use Access for that.