[AccessD] 2 Questions

jwcolby jwcolby at colbyconsulting.com
Wed Mar 10 13:08:19 CST 2010


LOL, quite right.  Substitute RI at your discretion.  8(

John W. Colby
www.ColbyConsulting.com


Max Wanadoo wrote:
> Ok...
> 
> When I went to school, RE stood for Religious Education.
> 
> Seems we have some of that going on here as well...no?
> 
> Max
>  
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
> Sent: Wednesday, March 10, 2010 6:52 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] 2 Questions
> 
> Ooh we haven't had a good rant-thread for ages. Makes me quite nostalgic.
> Just like old times. Go guys.
> 
> Andy
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
> Sent: 10 March 2010 17:37
> To: accessd at databaseadvisors.com
> Subject: Re: [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.
> 
> 
> --
> 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