Industry


Ads by TechWords

See your link here


Sharky's picture
Sharky

Shark Tank

Shark Tank: Update time

This company uses Microsoft Access for much of its database needs -- and database changes often require this pilot fish to get several users out of Access so he can update the applications.

"Somebody told me I'm grumpy when I do the updates," says fish. "But this is the time line of how the last update went."

10 a.m.: Fish sends out a companywide e-mail asking everyone to be out of several Access databases at 4 p.m. that afternoon so he can perform an update. He reminds all users that the databases will not be available for about 15 minutes after 4 p.m.

10:05 a.m.: Fish begins receiving sarcastic e-mails from co-workers, intended either to mock him or to critique his grammar, spelling and attitude.

11:15 a.m.: Despite the fact that fish clearly identified which databases would not be available during the update, somebody calls him to ask if he can use one of them during the update. The day passes...

4 p.m.: Fish starts asking users to get out of the databases. Users claim they either didn't get the message, never check their e-mail, were too busy and forgot, or just don't care. One user asks for five more minutes to finish entering something.

4:10 p.m.: Everybody's finally out.

4:12 p.m.: Fish tries to start the update, but a user has started using the database again. He tells fish he "didn't get the message."

4:15 p.m.: Fish finally begins the update, which is supposed to be complete by now.

4:18 p.m.: User calls fish with an unrelated, non-urgent question, even though he knows fish has his hands full with the update.

4:19 p.m.: Another user calls to find out if he can get back into the database yet.

4:25 p.m.: Five-minute update is finally done after nearly half an hour.

4:30 p.m.: User who didn't get out of Access when requested complains that the update took longer than it was supposed to. Fish explains that if everyone had cooperated and closed out of Access when he asked, it would have been done on time. User gives fish a blank stare.

"I give up and go home," fish reports. "5 p.m.: I arrive home and have a beer. Or two. Or three..."

Submit your own true tales of IT life to sharky@computerworld.com. If Sharky uses it, you'll snag a snazzy Shark Tank shirt! You can also add comments by using the form at the bottom of this page.

See more Shark Tank stories at the Sharkives.

Join Shark Bait

Now you can post your own stories of IT ridiculousness. Join Shark Bait today and vent your IT frustrations to people who've been there.
Go to the
Shark Bait homepage
or
Post a story now

What People Are Saying

jwkmjrkh

jwkmjrkh

Ha! Companies that use MS

Ha! Companies that use MS Access for major company controls, are disasters waiting to happen. Usually, these company controls are being done by people with no idea how to develop software. I know, my last gig involved writing the documentation for just such an app.

Scott, with this kind of a

Scott, with this kind of a response you should give E-Harmony a shot. If that doesn't work, go back to the beer.

I arrive home and have a

I arrive home and have a beer. Or two. Or three..."

It's called a de-griefing session.

Note to "Affraid to

Note to "Affraid to Say":

Find another job, NOW, while you still have your self-esteem and (relative) emotional stability.

Anon... I don't think my

Anon... I don't think my grammar is that bad. I'm sure my comments haven't been perfect, but I'm not writing a term paper here! My company-wide emails are usually pretty good, but mistakes happen. Now that I think of it, Anon may be one of my coworkers, it wouldn't suprise me.

Yes, Access isn't ideal for business applications supporting multiple users. I can't argue with that. But that's what I know, and it works for us.

Ok, it's been fun but I'm finished. Thanks for the feedback!

I had a similar db

I had a similar db application which had a regular update cycle. I was fortunate enough that I had written code that if a specific value was set, the database could not be opened and a message would be given that this was for updates.

It didn't help with the muppets who refused to close the application if they already had access to the database, but it was a start!

Fish has to deal with Access

Fish has to deal with Access in a production environment and smart-ass comments from users when he tries to do his job. I wouldn't stay one minute late to accommodate them either.

I haven't read through all

I haven't read through all the comments, but isn't the first issue here that several users are accessing a MS Access database. My understanding is MS Access was designed to be a single user database and any application allowing multiple users is destined to failure. We've had a few on our systems and learned the hard way. Now I never let our IT developers use MS Access for multi-use systems.

The first paragraph should

The first paragraph should be all the evidence anyone here needs to know that the fish works at a small company. In those places management decides what IT needs to do IT's job. At one place I was the sole IT person, but had to get permission from my supervisor, who had no computer skills, to buy even patch cables. I had begged and cajoled to get the LAN upgraded from Win 98 machines to 2000 or XP Pro. My main concern was regulatory, in that the federal government standards clearly did not allow for such a setup. We eventually upgraded, but only because the agency in question basically reamed us for it.

It seems that most of the posters here live in some universe where IT people decide IT issues. Terms like change management do not mean anything to people who do not like computers. Such people only want the computers to work, not provide what is needed to actually make them work. They also need someone to blame for when they do not work. For those posters who like to say that it is IT's job to win management's buy-in for IT policies and the failure to do so is IT's fault, write the book on how to do so.