It Just Works

Access is a database application that just won’t die, and it’s the subject of a short piece that discusses the reasons why the platform is still in use and thriving in some cases. I wonder how many of you still use, or support, databases that are built in Access and used by people in your organization to get work done.

Like many SQL Server pros, I’ve often dismissed Access as a poor tool for running an important database system. However, that’s been based on my experience with larger organizations that need to scale up a system for multiple people to use concurrently. Access doesn’t do that well, though it can certainly handle a small number of people easily.

Perhaps my disdain is also born from experience with Access being used to edit data in SQL Server and taking table locks. That usually builds a blocking chain that ends with my phone ringing, something I try to ensure doesn’t happen. However, that’s a broad brush against Access. I have a SQL Server DBA friend that used to use Access to edit lookup data. This person would even give a form in Access to a few employees to allow them to maintain some data in SQL Server. Without any issues.

Access is easy to get up and running, which isn’t something I’d say about SQL Server. I’ve used most versions of SQL and built applications on the platform. Getting going quickly, without overhead, isn’t something I think about. Even security, which I understand well, isn’t simple to explain or get right. I see plenty of people struggling with this constantly, which is likely why many vendors end up using the “sa” account.

There are lots of reasons why SQL Server (or some other server) is a better database platform for an application with any widespread usage. There are also reasons why Access is a good platform for small systems. I’ve run into a few Access MVPs that are still building and maintaining applications for small customers, with no shortage of work and plenty of accolades from their clients. Maybe the last part of the article says it the best why Access is still in use: ” the attraction of something that “just works” has turned many ordinary technologies into overnight sensations.” I couldn’t say it any better myself.

Steve Jones

Listen to the podcast at Libsyn, Stitcher or iTunes.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Editorial and tagged . Bookmark the permalink.

6 Responses to It Just Works

  1. Kurt Zimmerman says:

    Well I support an Access database platform. It is an application that has been developed over a decade ago and it just works…. It doesn’t do much and can easily be ported over to a newer platform. However, there are some issues doing that. First it utilizes a linked table into a proprietary platform. Here is more background. The owners of my company have billions of dollars with a large banking institution. The Investment Manager pulls down a daily report in Excel. In addition the IM manages balance information in a proprietary system. Every morning the IM runs a series of macros that loads the excel spreadsheet and pulls data from the proprietary system to load a couple of tables. Then a series of reconciliation reports are run to compare both sources. The series of queries in this system are quite simple. It could easily be written in a host of other platforms. The question is, WHY DO IT? It WORKS. There is no reason to rewrite the process utilizing manpower to redesign/develop/test/implement this process. It just works. No need to reinvent the where.

    Like

  2. Kurt Zimmerman says:

    *No need to reinvent the wheel…

    Like

  3. way0utwest says:

    I agree. Working is a huge feature

    Like

  4. Barbara says:

    This is actually how I got my start with SQL Server is by learning about Access database tables, forms, VBA, reports and relationships. I prefer SQL Server but I wouldn’t be here today without Microsoft Access 2.0! The built-in wizards enabled me to learn to write SQL and how to do a bit of coding behind the forms. I had a ball back in the day playing in the “baby pool”!

    Like

  5. way0utwest says:

    Glad that worked out for you. And that you prefer SQL Server now

    Like

Comments are closed.