[MS_AccessPros] Re: referential integricy sql deletion

 

Liz

If you have set the relationship to use cascading deletes it will do it automatically. I, for one, rarely use cascading updates or deletes. I do include a bit (Yes/No) field named Active in any table where the user might want to delete a parent. I default the Active field to -1. Should the user want to delete the parent all that actually happens is Active is set to 0. All forms and reports have criteria that says Active = -1 so inactive parents don't show. That lets me keep an audit trail and not lose any records.

Another reason I don't use cascading in relationships is that it's just too easy to delete the wrong record and wipe out all the child records, especially if the record deletion warning has accidentally been turned off.

Bill Mosca

---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :

Pros, I should know this, but well, some of my inherited databases don't have referential integrity.

 

However, this new cool one I'm building myself does.  

 

If I issue an sql deletion statement from the main table, will it cascade deletes if that rule is in place or do I need to delete the subtables too?

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 |

beaerospace.com

Passion to Innovate. Power to Deliver

 

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___