Results 1 to 4 of 4
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    1,919

    Anyway to "Temporarily" turn on cascade deletes


    I have a normalized app wherein I want to delete a record that potentially is the head of a 4 level deep relational string of records. Is there anyway to "Temporarily" turn on cascade deletes?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    sure - go into relationships window and set the relationship accordingly. Do your deletes, then change the relationship back again

    Providing the existing data meets the rules it should not be a problem. But I don't understand why you only want to set it temporarily - unless it is to save writing an extra 3 queries - relationships form part of normalisation - or to be more precise help to manage data to ensure it remains normalised.

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    1,919
    To big of a risk to enable deletion cascades permanently. Even If I prompt for confirmation, I can almost guarantee the user will accidentally "cut" a wrong record and wipe out an entire group of records. I'm really weary of a backlash if one of the more naive users doesn't understand a confirmation prompt.

    What might be worth considering is to gather some information regarding the relational chain and present that information to the user as part of the confirmation prompt. That way, they'll at least be forewarned regarding the magnitude of their request.

  4. #4
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    1,919
    This probably isn't the place for an extended discussion regarding application design, so I'll just conclude here by saying the app does have a builtin password capability that is presented to the user in order to run privileged functions. I'll use that as a requirement before allowing the running of a few delete queries when the apps delete function is invoked. Seems that's the best I can do.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 04-01-2016, 11:25 AM
  2. Turn Off Warnings to Overwrite "ExportWithFormatting"
    By RogerD in forum Import/Export Data
    Replies: 2
    Last Post: 02-24-2016, 06:02 AM
  3. can't trap the "cascading deletes" error
    By MattPGA in forum Forms
    Replies: 16
    Last Post: 08-02-2015, 11:34 AM
  4. "cycles or multiple cascade paths" in Design
    By recyan in forum Database Design
    Replies: 51
    Last Post: 06-12-2013, 11:26 PM
  5. turn "about to delete record" warning back on
    By markjkubicki in forum Programming
    Replies: 1
    Last Post: 11-01-2012, 12:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums