Re:Microsoft Access: The Database Software That Won't Die
by _AzMoo on Wednesday October 30, 2019 @10:51PM
(#21405300)
Why would you do that though? The underlying database technology is not really one of the problems access has.
[ Parent
| on HN ]
Re:Microsoft Access: The Database Software That Won't Die
by onefuncman on Thursday October 31, 2019 @05:36AM
(#21407012)
Sure it is ... the database underlying Access uses JetSQL which has its own fun syntactic quirks
It's also very bad at concurrent users if you do go down the path of dropping it on a network share if it's a normalized schema, since there's no server to cache queries or do optimizations... for strictly data entry against a simple schema you can maybe push it to low 100s of users, but backing up / restoring / rolling out new versions is a nightmare when the frontend and backend are commingled like that. You can deploy different versions of .mdbs if you have an external backend, though I've never seen anyone do so with an Access database backing an Access "UI" project...
Re:Microsoft Access: The Database Software That Won't Die
by allannienhuis on Wednesday October 30, 2019 @11:26PM
(#21405485)
cross-platform might be one reason.