ThatJeffSmith

Access of Evil

A play on words – the Axis of Evil, three countries that foster or promote terrorism. This is not a history lesson or political discussion, go here for that.

So what is the Access of Evil? I would propose that the following practices conspire to bring down any well-ordered collection of data:

  • MS Access
  • MS Excel
  • SELECT *.
  • So do I have anything meaningful to add to this discussion at this point, or was I just pleased with myself for coming up with a funny blog title?

    When I show off software that helps move data FROM or TO Excel and Access, people go ‘oooooh’ and ‘ahhhhhhh.’ When I follow-up with a disclaimer that you should really think about why you are doing so, I get lots of nervous laughs and giggles.

    Terrorism, really?

    Harsh words perhaps, but there are enough horror stories out there to fuel the debate.

    I do not think any of these things by themselves are evil, but I do think a whole lot of evil has been accomplished with their help. I would even take a step further and say that they encouraged bad things to happen. Folks that normally would not be trusted with production data are now ‘empowered’ by tools that do not require a lot technical or data quality skills.

    Don’t be the guy or gal that made a business decision based on a spreadsheet someone made 4 months ago. And especially don’t be the guy or gal that builds the Access database that uses an ODBC link to SQL or Oracle that uses multiple SQL * FROM table1,table2,table3, … tableN statements.