[AccessD] 2 Questions

Hi Max

This may have been the case for you but it is not so in general. Cascade-delete does not delete all your data except if all tables are linked back to one single top-level table from which you "just happen" to delete all records.
And should you have set it up to do so, it would be for a purpose, and it will not delete the records without the usual warning.

Cascade-updates and cascade-deletes are excellent tools. Just learn to ride them. It isn't hard.

/gustav


>>> max.wanadoo at gmail.com 10-03-2010 18:14 >>>
...and if your very lucky, it will go on  and delete your whole data...all
without a so much as bye your leave.  Then it will be every so nice and
clean.

Great stuff these switches - not!

Be lazy at your peril!!

Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, March 10, 2010 5:00 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] 2 Questions

 > That's the beaty of cascade-deletes - the perfect clean-up tool!

ROTFL.  Indeed!

John W. Colby
www.ColbyConsulting.com 


Gustav Brock wrote:
> Hi John
> 
> That's the beaty of cascade-deletes - the perfect clean-up tool!
> 
> /gustav
> 
> 
>>>> jwcolby at colbyconsulting.com 10-03-2010 16:09 >>>
>  > As for how "dangerous" cascade-deletes are, it is not different 
> from any other action that alters or deletes data in the database.
> 
> Well... I disagree of course.  The problem is that cascade deletes 
> deletes EVERYTHING down to the last great-great-great-great grandchild 
> record (assuming Cascade delete everywhere).  That is pretty darned dangerous.