Access vs Excel. Why doest though detest so much IT Managers?


Many times we run into this all too familiar issue:

  1. IT doesn’t like Access.  They actually hate it.  And would prefer to see it out of the business entirely.
  2. I ask them why.
  3. It stores data which is NOT on the server.  And users control the data.  And users can steal the data.  And the software is expensive.
  4. Ask them if they allow Excel?  Yes, of course.

Hmmm.  and they are different how?  Excel:  stores data in a file.  data controlled by user.  User can steal the file.  Software same cost as Access.  Can be incredibly complicated and actually used as a database by some people.

So the question is actually “why does IT not understand and love it’s prodigal child Access”?  We are creatures of habit, and Excel was common long before Access.  Users got used to simple rows and columns, and used to mathematical formulas.  It became a defacto standard.  Today, IT doesn’t like Access because they can not easily support it (lack of skill and time to figure out how to use it), can not understand relational databases (lack of training, totally different skill set  – i.e. DBA) , and see it as a foreign system on their network requiring highly specialized support.  The issue is more IT than it is Access.

Next time IT tells you Access is not viable, and should not be in the network…share this with them and challenge them on the merits of Excel.

Related Posts

Access 2016 Relationships

Short blog today, this is a great read on relationships in Access 2016: Access 2016 Relationships Thanks to Microsoft for this one!

Microsoft Access Union Query from Hell. Skill Level: Demi-God

The worst query I ever had to write which powers a master report for the database user.  Here it is.  I don't think I can make it smaller, there were too many weird rules, aggregates, and translations in it.  And we needed to pull different columns based on criteria. ...



Submit a Comment