Hacker News new | ask | show | jobs
by codeulike 849 days ago
I never saw an Access database that didn't become a regretful mess after a couple of years - the person that made it left, no-one knew how to update it. Fancy validation built into the form that just got in the way when requirements changed.

Thus I came to the conclusion that any Access database is probably better off being a spreadsheet, even with all the chaos that not having forms as a front end and not having relational structure entails. At least people can understand other peoples spreadsheets (up to a point)
2 comments
EvanAnderson 849 days ago
Most Access-based apps turn to shit because they're made by non-developers. The tool itself isn't to blame. I've seen Access used to great success when coupled with scripting to dump schema and code to text files for version control and code review.
link
codeulike 849 days ago
Right, but if you're a developer you might as well use something more developery. Like the selling point of Access was supposed to be that non-coders could use it to knock together a database.

In the late 90s I built some quite big things in Access and promptly regretted it. I guess Access got used for those projects because the organisation already 'owned' it as part of the Office bundle whereas Visual Studio 6 was seen as 'expensive' (I think it was about £500 per developer or something).

But these days that problem would not occur. The days of development tools needing comparatively expensive licences are over.

link
EvanAnderson 849 days ago
> I guess Access got used for those projects because the organisation already 'owned' it...

> The days of development tools needing comparatively expensive licences are over.

That's exactly the motivation I saw for Access being used in the past. I agree, those days are over and that justification for using Access is moot.

link
account-5 849 days ago
I'm unfortunately forced to use access at work. I never wanted to learn what is, unless MS do something, a dead technology, I fully agree that most access databases are a shit show but only because nondevelopers (as mentioned but others). However, kept simple, on point and used within it's limitations, it's a very flexible system.
link