Drew Wutka
DWUTKA at marlow.com
Wed Oct 29 17:10:08 CST 2003
It's one of the rare luxuries of working with the computer inepts! <grin> The worst drawback though, is they have absolutely no concept of what can and can't be done. This hits me in two bad ways. I either find out that they have been spending hours, days, weeks, or even months, doing something that would literally take a fraction of the time if done through code. An example of this is our Hours program and Production database. The hours program is written in an OLD DOS db language (DataPoint), and our Production db is Glovia (which uses Oracle as a BE). Hours was written by an in house programmer, from the days of yore (who still works 10 hours a week here to maintain the old legacy systems he wrote...they're mostly accounting stuff, and I don't think you want me to get into what I think of accounting, or the situation with them...they are my kryptonite! <grin>), and Glovia isn't a bad package, but we are using an old version, horrible in a windows environment, and it's only partially implemented...worse yet, no one truly knows what they are doing with it. Everything is done strictly from tribal knowledge. Anyhow, one day I found out they were getting a file dumped out of hours, that they were then turning around and manually dumping it into Glovia. It was taking an account close to a full work day to do. Admittedly, it was only once a month, but 8 hours a month is 416 hours a year.....starts to add up. In about 1.5 hours I had a VB program that pulled up the flat dump file, worked with the data the right way, and dumped it straight into Glovia (into the Oracle db). The actual process takes about 15 seconds.....now, they had been doing it the other way for 4 or 5 years (however long they had Glovia).....yet they didn't want to change it, because they thought it would be too difficult to do! On the other extreme, I get hit with the nearly impossible. I don't mind the mentally challenging stuff, I'm talking about the technology blocking stuff. Like 'Can we find a faster way to transfer a few gigs of files over our T1?'. Um ya, upgrade to a T3! <grin> Drew -----Original Message----- From: Frank Tanner III [mailto:pctech at mybellybutton.com] Sent: Wednesday, October 29, 2003 2:51 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Yes. Another Silly Access Question. I wish I had that kind of autonomy with the MS Access stuff. I have that with the entire LAN and WAN infrastructure. There are places in the buildings that not even the company president has the access to go, of course he could get it. Same with passwords, etc of all of the equipment. They leave all of that to me and they don't want to know, as long as it works. However, these little "side projects" like this one, they want total control over. --- Drew Wutka <DWUTKA at marlow.com> wrote: > LOL. Actually, I have the only password in the > company that no one else > knows (though my co-worker may know it.) It's > l0phtCrack proof, and I have > all of my Data drives on this machine set so only my > account can read them. > My boss has asked me why a few times, and I just > stick to one story. I > don't want anyone to goof with any of my current > projects. Simple story, > and it works. He knows he doesn't have anywhere > near a strong enough grasp > of what I do to go mucking around in my data files. > > Drew > > -----Original Message----- > From: Frank Tanner III > [mailto:pctech at mybellybutton.com] > Sent: Wednesday, October 29, 2003 2:04 PM > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] Yes. Another Silly Access > Question. > > > Sure. I can see it now.... > > "No, Ms Senior Vice President. You cannot view the > work that I have done. I know you're my boss and > the > second in command of the company, but you're not > authorized to see it." > > I'd have a job for about as long as it took them to > fill out the insubordination write-up and > termination > papers. > > --- jeffrey.demulling at usbank.com wrote: > > > > Make sure they cannot do a code review by making > an > > MDE and then do NOT let > > them near your source MDB. > > > > > > > > > > > > > > "Frank Tanner III" > > > > > > > > <pctech at mybellybutton.com> > > > To: "Access Developers discussion and problem > > solving" > > Sent by: > > > <accessd at databaseadvisors.com> > > > > > accessd-bounces at databasead > > > cc: > > > > > visors.com > > > Subject: RE: [AccessD] Yes. Another Silly > > Access Question. > > > > > > > > > > > > > > > > > > 10/29/2003 01:47 PM > > > > > > > > Please respond to "Access > > > > > > > > Developers discussion and > > > > > > > > problem solving" > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > It works like a charm...... Presupposing they > don't > > do > > some sort of code review. > > > > Even a novice can say, "Hey! We told you to make > > three tables. There's only one here." > > > > --- Drew Wutka <DWUTKA at marlow.com> wrote: > > > Works like a charm, don't you think? > > > > > > Drew > > > > > > -----Original Message----- > > > From: Charlotte Foust > > > [mailto:cfoust at infostatsystems.com] > > > Sent: Wednesday, October 29, 2003 10:54 AM > > > To: Access Developers discussion and problem > > solving > > > Subject: RE: [AccessD] Yes. Another Silly Access > > > Question. > > > > > > > > > That's the approach I use as well, Drew. I give > > > them the result they're > > > looking for and hide the details so they don't > > > realize I did it right > > > instead of the way they wanted it done. > > > > > > Charlotte Foust > > > > > > -----Original Message----- > > > From: Drew Wutka [mailto:DWUTKA at marlow.com] > > > Sent: Tuesday, October 28, 2003 9:54 AM > > > To: 'Access Developers discussion and problem > > > solving' > > > Subject: RE: [AccessD] Yes. Another Silly Access > > > Question. > > > > > > > > > I hear ya, on your situation. I've been in the > > same > > > boat many > > > times....fortunately, the people I work with > don't > > > have the first clue > > > of what I do/know, so I just do it my way > anyways. > > > <evilgrin> > > > > > > Drew > > > > > > -----Original Message----- > > > From: Frank Tanner III > > > [mailto:pctech at mybellybutton.com] > > > Sent: Monday, October 27, 2003 1:27 PM > > > To: Access Developers discussion and problem > > solving > > > Subject: RE: [AccessD] Yes. Another Silly Access > > > Question. > > > > > > > > > To quote my DI when I was in the > military..."Mine > > is > > > not to question why. Mine is but to do or die." > > > heheheh > > > > > > Sometimes, regardless of how much you try to > talk > > > sense into people, they still wanna do what they > > > wanna > > > do. And Marketing wants to do what they want to > > do. > > > > > > Since their boss (The company Sr VP) is also my > > > boss, > > > I lose....hehehe > > > > > > --- Drew Wutka <DWUTKA at marlow.com> wrote: > > > > Is there a reason you have a big frown after > > > > thinking I was on the Mark! > > > > <evilgrin> > === message truncated === _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com