[AccessD] 2 Questions

Max Wanadoo max.wanadoo at gmail.com
Wed Mar 10 13:37:36 CST 2010


OOPS, sorry. I nearly fell off my chair then.
For one silly moment, I thought Charlotte was agreeing with me.
Then I though .."nah!, couldn't be. Still hot in hell - not frozen yet".

Silly me!

Max
 

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

It will if you're so ill-advised as to set warnings off!

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, March 10, 2010 9:37 AM
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
 

--
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