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

Gustav Brock gustav at cactus.dk
Sun Feb 2 14:47:00 CST 2003


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




More information about the AccessD mailing list