Don’t knock MSAccess

Part of my daily work includes supporting various Microsoft Access databases, and I’ve been building things with MSAccess for about 11 years now.  However, I’ve learned not to mention Access when talking to other developers, as it gets one roundly mocked and, often, sneered at. It seems that ‘real’ developers view Access as a ‘toy’, or worse, a force of evil that allows users to create nightmarish applications that ‘real’ developers then have to support.

But Access itself is not intrinsically evil, it is just a tool. Yes, I’ve seen some horrific examples of just what you can do with MSAccess. But we all make mistakes while learning; the problem really is that businesses then use these badly-designed systems to do important jobs. It is always a mistake to run mission-critical processes on some software written by your nephew as a college project. Yes, the development cost is cheap, but the maintenance cost, or cost to your business in errors, will be high.

There was some discussion at work about whether we should restrict access to Access (sorry!) to stop people being able to create databases. I’m a great believer in empowering users and letting them learn, so I don’t really agree with this approach. But, not wanting an exponential growth in support issues, my policy is that I will help but not support. If you want to learn, learning by mistakes is the best way, and the idea that I won’t bail you out if it all goes nasty hopefully will prevent managers from allowing any of these creations to become critical parts of a business process. I’m an optimist.

  • Share/Bookmark

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

This entry was posted in Access and tagged , , , , , . Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>