Results 1 to 5 of 5
  1. #1
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Operation Not Supported in Transactions (Access 2002)

    Today I ran across an interesting and frustrating error and thought I would share the results of my research. In Access 97, we customarily used an OnDelete event in forms and subforms to trap the user pressing the delete key, setting Cancel = True and informing the user they had to use the Delete button on the form. This worked fine and we used it extensively. However, today someone tried it in 2002 and started getting strange error messages "Operation Not Supported in Transactions". Since we weren't using a transaction, I knew something was awry. We couldn't find any specific code that triggered it, but it always happened after the Delete key had been pressed and the user got the message telling them they couldn't do it that way. Research turned up the culprit, an acknowledged bug in Access 2002 and described in MSKB article 295229, ACC2002: Error Message: Operation Not Supported in Transactions. Now we have the charming task of changing all the forms that used this in 97 to use the BeforeDelConfirm event instead in 2002. <img src=/S/headthrob.gif border=0 alt=headthrob width=15 height=15>
    Charlotte

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Operation Not Supported in Transactions (Access 2002)

    Just for information, i have tried to reproduce the error (as described in the MSKB article) in Access 2003 and it seems to have been fixed.
    Regards
    John



  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Operation Not Supported in Transactions (Access 2002)

    So which event works, OnDelete or BeforeDelConfirm? If either of them will work, I'm happy. If only one works, I'm not.
    Charlotte

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Operation Not Supported in Transactions (Access 2002)

    All I have tested is that the bug reported in the MSKB article (which occurs when you use the OnDelete event with Access 2002) does not occur in Access 2003.

    So assuming this bug is the same as the one you experienced, then it is safe to use the OnDelete event in 2003.

    Neither you, nor the MSKB article, mention any problems with the BeforeDelConfirm event, so I imagine it is safe to use that event as well, but I have not tested it.
    Regards
    John



  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Operation Not Supported in Transactions (Access 2002)

    I didn't say there was a problem with the BeforeDelConfirm, it's just that it happens *after* OnDelete, so you would have to avoid any code in the OnDelete event that might trigger a Cancel there or the BeforeDelConfirm never happens and in XP you'll still get the error message. <img src=/S/groan.gif border=0 alt=groan width=16 height=15>
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •