Turning off Cascading Delete Message (1 Viewer)

ions

Access User
Local time
Today, 06:39
Joined
May 23, 2004
Messages
785
Hello

1. I wasn't sure where to put the Docmd.setwarnings False and Docmd.setwarnings True to disable Cascading Delete messages.

Currently, I've put them on OnDelete (FALSE) and AfterDelConfirmation (TRUE) is this sufficient?

2. Also even when I didn't turn setwarnings to False the Cascading message wouldn't consistently show up. Most of the time it wouldn't show and there was no pattern to when it would show up. However, the deletes were always made despite that warning not showing up.

NOTE: I checked my project for Docmd.setwarnings FALSE leaks and there were none.

This made my confidence in Access go down a notch. Access should be consistent and show the message each time if warnings are TRUE

3. Is there a way to turn off cascading warnings all together so I don't have to trap them?

As always thanks to all the support on this forum
 

ions

Access User
Local time
Today, 06:39
Joined
May 23, 2004
Messages
785
It appears MS Access MVP's don't recommend Cascade Deletes. Instead they suggest to just delete the records yourself prior to deleting the parent record.

Hence I will delete it myself and take cascade delete off which resolves the message issue.

Some links by Access MVP's descriving their dislike of Cascade delete.

http://groups.google.ca/group/microsoft.public.access/browse_thread/thread/de80b42e12df1c69/d8f2570f03af0956?lnk=st&q=Cascade+Delete++Ms+Access&rnum=2&hl=en#d8f2570f03af0956

http://www.granite.ab.ca/access/cascadeupdatedelete.htm
 

Users who are viewing this thread

Top Bottom