Many times we run into this all too familiar issue:
- IT doesn’t like Access. They actually hate it. And would prefer to see it out of the business entirely.
- I ask them why.
- 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.
- 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.