Wednesday, June 28, 2006
MS Access sucks
Before I continue, I just want you to know that this is not an anti-MS post, not even against Office; it is against MS Access as a development environment.
So you open the thing (MS Access) and things look simple: Tables, Queries, Forms etc...
You begin by creating a few tables and their relations, everything's cool... until "There was something wrong here but I won't tell you because I am a bitch".
Really, the error messages there are horrifying, you open the help and it floods you with so much crap that you just feel like re-doing everything.
Tables are done? no problem we have another challenge for you; make a form:
The form designer is so unattractive and inappropriate, I mean, if you look at real development environments, form designers look solid while in Access, you get something like a Word document designer.
And what pisses me off mostly with using Access is the lack of programmatical freedom; things are way too automatic there, you get a feeling that things aren't in your control and you somehow navigate this whole project until it's finished.
Anyway, let's get to the bottom of things... let's ask ourselves what MS Access is supposed to do?
So it was aimed for people who are not programmers who want to create information systems for their organizations... but let's get real, is it even possible to create a decent information system without using a little bit of programming?
I believe it was an attempt to mix between Office and Visual Basic and whatever.
So people, don't use MS Access unless a) you have to or b) you are masochist.
(Took me a while to post this article)
So you open the thing (MS Access) and things look simple: Tables, Queries, Forms etc...
You begin by creating a few tables and their relations, everything's cool... until "There was something wrong here but I won't tell you because I am a bitch".
Really, the error messages there are horrifying, you open the help and it floods you with so much crap that you just feel like re-doing everything.
Tables are done? no problem we have another challenge for you; make a form:
The form designer is so unattractive and inappropriate, I mean, if you look at real development environments, form designers look solid while in Access, you get something like a Word document designer.
And what pisses me off mostly with using Access is the lack of programmatical freedom; things are way too automatic there, you get a feeling that things aren't in your control and you somehow navigate this whole project until it's finished.
Anyway, let's get to the bottom of things... let's ask ourselves what MS Access is supposed to do?
So it was aimed for people who are not programmers who want to create information systems for their organizations... but let's get real, is it even possible to create a decent information system without using a little bit of programming?
I believe it was an attempt to mix between Office and Visual Basic and whatever.
So people, don't use MS Access unless a) you have to or b) you are masochist.
(Took me a while to post this article)