Interesting Read

[NauticalGent]

I stumbled across this article this morning while I was prepping for today's trials and tribulations.

The author's words really spoke to me about what I am going through right now. The current project I am on IS a big hairy mess - but instead of taking the time to determine what the original Dev was trying to do - we're talking identical Forms, Macros, BAD table design, etc... - I thought I could just take a scorched-earth approach and make a better mouse trap.

And I HAVE made it better, cleaner and more professional looking, but it was taken a lot of blood, sweat and tears and worst of all ,TIME to make it happen, and I am still not finished.

What is worse, the original Dev is still on the project and was at my disposal. Had I made him my first resource instead of my last resort, things would have gone a lot smoother.

You can tell some fools to come in out of the rain, some of us have to get wet first.

 

[arnelgp]

i like this line and still true, marketing old codes...

"You are putting yourself in an extremely dangerous position where you will be shipping an old version of the code for several years, completely unable to make any strategic changes or react to new features that the market demands, because you don’t have shippable code. You might as well just close for business for the duration."

 

[Isaac]

I agree, 90% of the time it's way harder for me to take over already existing work.........probably my fault somehow, but sheesh

 

[The_Doc_Man]

I "officially" got into Access programming and joined this forum EXACTLY for a situation like this, where a guy named Gene built a database that used an Excel spreadsheet as its main table. I cannot tell you how long it took to convince the engineers WHY they had to stop using a spreadsheet that locked up any time two of them tried to update it at once. I can't tell you how often there were yelling and screaming matches. But I got it beat into shape over a period of a couple of years. Then, in true "government contractor" fashion, had to give it up to a civil servant who THOUGHT he understood Access in specific and databases in general. I was told to keep my hands off. So I did, which turned out to be an act of malicious obedience. To say he "screwed the pooch" somehow is inadequate. He screwed that pooch so bad that I fully expected virulent little old ladies from the American Kennel Club to chase him with pitchforks, burning torches, tar, and feathers. And unfortunately, YES that was a case where trying to start over from scratch wasn't allowed. I was required to adapt it. The hardest part of adaptation was that Gene apparently didn't understand the concept of normalization. I leave it to you to contemplate the horror of that moment. A 1940s epic horror film with Boris Karloff and Bela Lugosi wouldn't have come close to the horror of the moment.