[AccessD] Cascade-delete (was: Estimating Help)

Drew Wutka DWUTKA at marlow.com
Sun Feb 2 20:05:01 CST 2003


Boy, things are getting a little touchy around here.  Suggesting JC joins a
club with me! <VBG>

Drew 

-----Original Message-----
From: Gustav Brock
To: John W. Colby
Sent: 2/2/03 2:46 PM
Subject: Re: [AccessD] Cascade-delete (was: Estimating Help)

Hi John

I wonder why you constantly miss the point. For all those horror
scenarios you paint up, all of us - me, Jeanine, John B, Andy,
yourself and any responsible developer - would of course set
cascade-delete to off.  

But for the purpose of automatic clean-up of otherwise completely
useless and orphane data, I have never seen cascade-deleting fail.

I have enough else to do than to recode tools already there.
Seems like you can join a club with Arthur and Drew on building delete
queries!

> I can now walk (or remote access) into your environment and wreak
havoc with
> your database, not having a clue how things relate to other things
etc.
> Don't think for a minute it doesn't happen.  I am hired by the
engineering
> office down the hall (or on the other side of the country).  You don't
even
> know I exist.  I delete your stuff.  You jump up and down, swear,
shoot your
> users, are arrested and hauled off to jail.  And I don't even know
that you
> are angry.

I hope this is a joke. At least it's not the way I entry unknown land.
And I would make a backup as the very first step. Then no one gets
angry - not even yourself when you make a mistake.

/gustav

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list