An IT Question: Are Access Database The Problem Or Only A Symptom? Mon 08 Sep 08
User-written Access databases (and other similar applications) always present a number of issues for IT. Issues of on-going support, documentation, testing, Sarbanes-Oxley compliance, security, backup, licensing, disaster recovery and so on. They represent all of the challenges that we continually work to minimize.
Some in IT view Access databases as the root cause of these issues and therefore the solution is clear. Let's solve the problem by outlawing Access databases and limit user ability extract data from or to update data in the ERP systems other than through IT provided means. No more user-written systems, no more issues.
Others view these user-written systems as a symptom of a larger issue. The larger issue being that users take this route because IT doesn't give them a better alternative. They don't feel IT is responsive enough to their needs and therefore they must take matters into their own hands. Those that believe the Access database as a symptom issue don't believe we can ever eliminate them (users will always find away to meet their needs) until IT resolves the issue of responsiveness thereby providing a better alternative to users?
How do you view Access databases? Are they the root cause of the problem or are they symptoms of bigger issues?
"Help" photo by Cobber99
Got a question you'd like me to post for future discussion? Email it to me using the "Email Mike" link in the left hand column.
If this topic was of interest, you might also like the other posts in the IT Question category.
An IT Question: What Do You Expect From The Project Sponsor? Mon 28 Jul 08
Occasionally I turn the tables and ask you the readers for you input and since it has been awhile since I've done that this seems like a good time. Here's the scenario--
A major IT project for the Sales department is about to kick-off. You stop by to talk with the with the VP, Sales about it and the dialog goes something like this.
VP, Sales - My team has told me they are excited to finally get this project going. We've been wanting it for a long time. We really expect to see a lot of benefit from this.
You - I'm glad to hear that. As you're the Project Sponsor we really appreciate your help in getting this done.
VP, Sales - I'm behind this a 1,000%! You can count on me. Make sure to let me know when it is done I'd like to host a congratulatory dinner for everyone on the team.
You - Well I truly appreciate your support but we need more than that. Your active participation is required if we want this to be successful.
VP, Sales - Oh. (significant pause) What exactly is it you want me to do?
You - . . .
How do you respond? What do you expect your executive project sponsors to do? What is their responsibility?
"Help" photo by Cobber99
Got a question you'd like me to post for future discussion? Email it to me using the "Email Mike" link in the left hand column.
If this topic was of interest, you might also like the other posts in the IT Question category.
An IT Question: Disappearing Car Doors and the Theory of Negativity Mon 17 Dec 07
Liz Strauss has called me an SOB. I actually find that very flattering since it doesn't mean what it usually means (which according to Wikipedia is actually quite a few things). Anyway because of this I try to faithfully check out her weekly listing of new SOBs she's found. This week iDunzo.com was one and I was floored by the post that happened to be the most current one. It seems a company called JaTech has developed a disappearing car door - that's right it disappears. Check out the video.
When I Googled this I was even more floored by the reactions to this new technology. Most of them were overwhelmingly positive expressing the same amazement that I felt. However, I was caught off guard by the reaction of some who couldn't help but dwell on problems and issues.
Some examples:
Continue reading "An IT Question: Disappearing Car Doors and the Theory of Negativity" »
An IT Question: What Has Disaster Taught You? Mon 12 Nov 07
Experience, it is said, is the best teacher. Oh so true. I guess that is why we do disaster recovery tests rather than just waiting until disaster really strikes. This got me thinking - what is the most surprising thing you learned as a result of an actual disaster recovery or even a test?
Mine was that people expect your disaster recovery process to cover everything. In one of my previous jobs we had a major fire at the corporate office and it was necessary to relocate people to the plant about one hundred miles away. From an IT standpoint we were able to keep things running and or data loss. What surprised me was that when people came to the plant they expected IT to provide them with a PC, which we did, but a PC complete with office, furniture, office supplies and administrative assistants. Apparently when people fail to plan for disasters they look to those that have a plan as their rescuers for everything.
So, what is the most surprising thing you learned as a result of an actual disaster recovery or even a test?
[Update 10/12/2007 afternoon - corrected typos including "did not suffer any systems downtime" and "they look to those that have a plan"]
"Help" photo by Cobber99
Got a question you'd like me to post for future discussion? Email it to me using the "Email Mike" link in the left hand column.
If this topic was of interest, you might also like the other posts in the IT Question category.
An IT Question: Who Should Pay? Wed 12 Sep 07
Now that budgeting season is upon us I thought I'd ask a question about who should pay for your IT services.
Should you charge your users based upon how much service they get from IT? Will this drive them to the lower cost "shadow IT" with its inherent risks and problems? Since they are paying will they opt out of programs and policies that are in the company's best interests?
Conversely, should IT be free with no charge to the users? This may encourage them to use IT but will it be done effectively?
My question is "Who should pay for IT?" What do you think? How do you do it at your company and why?
"Help" photo by Cobber99
Got a question you'd like me to post for future discussion? Email it to me using the "Email Mike" link in the left hand column.
If this topic was of interest, you might also like the other posts in the IT Question category.
An IT Question: Are Some People Special? Wed 22 Aug 07
It's Friday afternoon and your already thinking of the weekend when your Help Desk lead comes walks briskly into your office. "We have to talk", he demands. He goes on to excitedly explain that he just got off of the phone with one of the VPs. It seems the Veep wants his more storage space for his email inbox. "Doesn't he know our standard is to set everyone up with the same amount" the tech blurts out in an ever loudening voice as his face gets redder. "And what about those engineers, they claim they need more than the allowed amount of network storage for their precious test data" he says as the veins begin to show in his forehead. "Last week it was the HR folks claiming they need personal printers because of all the "confidential" work they do. I bet they are just trying to get around our standard of having everyone on network printers." Earlier in the day it was the graphic arts department wanting to get Macs because someone told them it would they fit their needs better. "My gawd, don't they know we're a PC only shop!", he exclaims. With arms flailing and spittle flying he lets out one last desperate cry - "What do these people think they are -- Special?" and then collapses to the floor.
It seems that in all the excitement he has forgotten to inhale and has collapsed from a lack of oxygen. Fortunately, being a well-prepared IT leader you have a staff of paramedics on call in the office next to yours for just such emergencies. While the paramedics bring the tech back to consciousness you stop to think, you know as soon as he starts breathing he's going to want your response.
So, how do you respond? Are some people special and deserve special treatment? If so, how do you determine who is special? How do you answer people when they ask, "Aren't I special too?"
"Help" photo by Cobber99
Got a question you'd like me to post for future discussion? Email it to me using the "Email Mike" link in the left hand column.
If this topic was of interest, you might also like the other posts in the IT Question category.
An IT Question: Blocking Non-Business Internet Sites Wed 01 Aug 07
One of the company Vice Presidents stops by your office and expresses concern that some of their people may be spending too much time on the Internet and wants to know if there is any thing you can do about it. You mention that you do have a filtering program but it is set only to filter objectionable sites such as gambling, porn, etc. You explain to that filtering non-offensive but seemingly non-business related sites may be counter-productive as it is often difficult for IT to determine which sites truly have no business application. You go on to cite examples of the need to view sports, restaurant, job boards, real estate and other sites was business related. The VP is not impressed and insists that you block all sites that are not obviously and directly related to your company's business. You know other VPs do not have this concern.
How do you respond to this request to block Internet access to "non-business" sites?
"Help" photo by Cobber99
Got a question you'd like me to post for future discussion? Email it to me using the "Email Mike" link in the left hand column.
If this topic was of interest, you might also like the other posts in the IT Question category.
An IT Question: How Far Does Your Responsibility In Training Go? Wed 25 Jul 07
I often hear IT folks comment on the lack of knowledge of computers and systems within the user community. When the discussion turns to training, techniques like user manuals, classes, FAQs and online help are often mentioned. And yet our users still don't seem to have the knowledge they need to utilize the computers and systems efficiently and effectively and we are taken to task for this. It seems as though we want to be held accountable for our efforts (providing the training) - the things we can control. However we are often measured on the outcome (how much the users learn) - something not entirely within our control.
How far does our responsibility go in making sure our users are properly trained? Is it our job to simply provide the training or is it to make sure people are adequately trained? What do you think?
"Help" photo by Cobber99
Got a question you'd like me to post for future discussion? Email it to me using the "Email Mike" link in the left hand column.
An IT Question: Responding To A Request For "Just An Access Database" Wed 18 Jul 07
It's not unusual for a user with some degree of familiarity of PCs and programming to come to IT with a request - "I need help developing an Access database to analyze ZZZZ". You know that the Access database could be done quickly and you know that the database would be beneficial. You also have some concerns about security, documentation, testing, backup and support with these user developed systems. Due to resource constraints it will be at least 6 weeks before you can provide an IT solution compared to a few days if you help them develop the database on their own.
How do you respond to this request?
"Help" photo by Cobber99
Got a question you'd like me to post for future discussion? Email it to me using the "Email Mike" link in the left hand column.

Tell a Friend About Mike's Blog
Blogs I Read
- Robin Kessler
- IT, Web 2.0 and Social Media ramblings of Steve Francia
- A CIO’s Voice
- The Effective CIO
- Aligning Technology, Strategy, People and Projects
- Andrew McAfee
- Candid CIO
- Daniel Johnson, Jr.
- Here We Are. Now What?
- JibberJobber Blog
- Kent Blumberg
- Net Objectives Thoughts
- Practical Analyst
- Rough Type: Nicholas Carr
- Web 2.What?
Full Archives
www.flickr.com
|
A Few of My Favorite Posts
- Guiding Principles For IT
- 'I taught it, they didn't learn it, it's on them'
- Twitter's Corporate Message
- IT Doesn't Have To Be Annoying
- Selling Web 2.0 To IT
- What's In A Title / Job Description - Programmer, Developer, System Analyst, Business Analyst
- The Un-Marketing of IT - The Survey Results
- The Un-Marketing of IT
- CIO Job Description And The Need For Technical Experience
- Using Widgets To Compete - Companies must use Web 2.0 technologies to stay ahead of rivals.
- Business Analyst Job Description
- Why Companies Need Web 2.0
- Are you efficient but ineffective? Or effective but inefficient?
- Let's Hang Up The Gloves
- Take The Test: Are You An IT A**hole Or An IT Hero?
- Selling the Software: 4 Questions You Need to Answer
- Another Day In Paradise?
- It's Not What You Say, It's What People Hear
- Why I Blog: 10 Reasons to Blog To Establish Your Personal Brand
- Let's Get Down to Business
- Let's Get Strategic!
- IT is NOT Your Mother!
- IT Needs To Become More Like "Shadow IT"
- Critical Skills and Competencies for IT employees
- Why It's Time to Lose the Snide IT Attitude
- CIO Competencies
- Execution - Keep Your Eyes on the Prize
- ITBWA - How Dirty Are Your Shoes?
Recommended Books
Douglas W. Hubbard: How to Measure Anything: Finding the Value of "Intangibles" in Business
Orville Pierson: Highly Effective Networking: Meet the Right People and Get a Great Job
Jason Alba: I'm on LinkedIn -- Now What???: A Guide to Getting the Most OUT of LinkedIn
Robert I. Sutton: The No Asshole Rule: Building a Civilized Workplace and Surviving One That Isn't
Nick McCormick: Lead Well and Prosper: 15 Successful Strategies for Becoming a Good Manager
Frank Luntz: Words That Work: It's Not What You Say, It's What People Hear
Robin Kessler: Competency-Based Resumes: How To Bring Your Resume To The Top Of The Pile
Susan D. Strayer: The Right Job, Right Now: The Complete Toolkit for Finding Your Perfect Career
Marilee G. Adams: Change Your Questions, Change Your Life: 7 Powerful Tools for Life and Work
- Wendell Johnson with Dorothy Moeller: Living with Change the Semantics of Coping
Jeffrey Liker: The Toyota Way: 14 Management Principles From The World's Greatest Manufacturer
Bill Carreira: Lean Six Sigma That Works: A Powerful Action Plan for Dramatically Improving Quality, Increasing Speed, And Reducing Waste
Good Overview of Lean Six SigmaPierre Mourier: Conquering Organizational Change: How to Succeed Where Most Companies Fail
This approach can improve the chances your project will be successful.Jared Diamond: Collapse: How Societies Choose to Fail or Succeed
Fantastic book with a lot of applicability to business.
Recent Posts
- The Tyranny of Rules
- Found Photos - Japan, 1958
- I've been taking a break . . .
- Better Communication: Technology Isn't Always The Best Solution
- A Tale of Apple, Microsoft, Google and Others For The Holiday Season
- Wikileaks Positive Side Effect for IT
- A New Blog by HR Competency Expert, Robin Kessler
- What Sarbanes-Oxley, Lawyers, and Auditors Really Mean for IT
- Why E-Commerce Still Isn’t Easy To Do
- Making IT Better For Customers
- "Bring Your Own Technology" Is In Your Future
- SIMposium2010
- How IT Can Give Better Presentations
- Why IT Must Embrace Facebook, Twitter, iPhone
- Top Five Technology Fanboys

Read My Articles via RSS feed