[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