I just completed an Excel application for a large International client wherein there is a small Excel file that they send out to collect information peridiodically from offices around the world. This file does not collect any data, it merely takes what they type in and pushes it back to an Access database through a UNC across the WAN that ALL users are connected to. They can add as many records as necessary and can even edit records they altready entered if they have not been processed. All the admin has to do is assign rights for users one-time so they can push (and pull) data from the Access database.
This application is very simple to deploy and maintain and the data ends up in the database instantly in real time. An inexpensive, efficient solution.
Well … the user just came back to me and asked whether they could just email out the Excel file so the user can type in their data and email it back because HE IS AFRAID THEY MIGHT NOT BE CONNECTED TO THE NETWORK WHEN THEY WANT TO USE THIS THING ….. and also because he realy doesn’t understand how this thng works.
I replied something to the effect that all these users have to be connected to the network SOMETIME (they’re all in major offices) and they should just wait until they ARE connected to use the spreadsheet file.
This is the second time this EXACT thing has happened in two separate corporations in the last year. A major example of this happened a couple of years ago as well in an especially galling scenario (where not only was the technology not used because they couldn’t get in their heads why the application worked – but I was still told I couldn’t even use the technology I developed for them anywhere else after regardless without their approval).
People just cannot get their heads around using a spreadsheet in any way other than the way they have always used it. How is this allowed to happen? How can we move forward with this kind of attitude in the “wilds” ??
This is a BIG problem and one that should be worked on by all of us.