Results 1 to 8 of 8
  1. #1
    panoss is offline Advanced Beginner
    Windows 7 32bit Access 2003
    Join Date
    Oct 2014
    Posts
    59

    Error 2074 this operation is not supported within transactions


    When I delete a record, I get the above mentioned error.
    I have attached a sample db so you can try it your self.
    1. It has one main form, bm.
    2. Main form has 2 subforms, bm_1 and bm_2.
    3. bm_2 has one subform, bm_2_1.
    4. When we click on the list, on current event of bm_1 is triggered, the function found in the module is called which returns a recordset which populates bm_2_1 form.
    5. Open main form (bm) and you 'l see a list in the datasheet.
    And on top-left a delete button with '-' in it.
    6. Select one of the records and press the delete button.
    Answer 'yes' to the prompt and you 'l get the error.

    Is there some way to fix it?
    (I tried setting the SourceObject (Forms("bm").bm_2.SourceObject = "bm_2") as suggested in some other thread, but nothing)

    bm_sample_1.zip

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Tell us about the application. I see 1 table. How do the related forms use data from this one table?

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    as suggested in some other thread, but nothing)
    does this mean you have posted this problem elsewhere?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    As orange has already said, you have one table with three fields.
    I can't see why you need a form and 3 subforms to display the data.
    A continuous or single form would work far better ...or if you prefer, a split form.
    It would also make deleting records simpler.

    Your data sheet subform is set to allow deletions. When I tried to do so rather than use your button, I got the same error
    I think the issue is the over complicated way you have designed this.
    Suggest a redesign.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    panoss is offline Advanced Beginner
    Windows 7 32bit Access 2003
    Join Date
    Oct 2014
    Posts
    59
    Quote Originally Posted by Micron View Post
    does this mean you have posted this problem elsewhere?
    No, I meant this.

  6. #6
    panoss is offline Advanced Beginner
    Windows 7 32bit Access 2003
    Join Date
    Oct 2014
    Posts
    59
    Quote Originally Posted by orange View Post
    Tell us about the application. I see 1 table. How do the related forms use data from this one table?
    The table is the bm.
    On the left you see this table in the datsheet(bm_1).
    On the right you see some fields (bm_2) of the currently selected record of the datasheet.
    In bm_2_1 you see the Alternative parts of the currently selected. (in a datasheet)

    (in the real application fields are much more but for the shake of simplicity I left only 3 in this sample. So on the right side we see (some fields of) the current record 'magnified', this is the logic.)

    Quote Originally Posted by ridders52 View Post
    Suggest a redesign.
    Well, this can't be done as the client wants it this way.

    (I forgot to mention, it's made with Access 2010)

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Even so its unnecessarily complex - a split form or similar would provide the same information and you wouldn't get your error.
    Suggest you tell your client the design is flawed
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  8. #8
    panoss is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2014
    Posts
    59
    I removed the code in the bm_1 current event that was used for updating the bm_2 subform.
    In it's place I used an 'old-fashioned' way: (like this)
    - a textbox on form bm with ControlSource set to key field of bm_1 (Manufacturer Part Number).
    - in bm_2 Link Master Fields is set to this textbox
    - Link Child Fields->Manufacturer Part Number

    And the error is gone!
    Thank you all for your help.

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

Similar Threads

  1. Runtime Error 3251 object not supported
    By avanduyvenbode in forum Programming
    Replies: 2
    Last Post: 10-18-2016, 09:54 AM
  2. Error - function not supported
    By Roger3322 in forum Queries
    Replies: 1
    Last Post: 10-21-2014, 09:59 AM
  3. Help with Error: Join Expression Not Supported
    By gammaman in forum Queries
    Replies: 1
    Last Post: 07-30-2013, 02:08 PM
  4. Operation is not supported for this type of object error
    By CementCarver in forum Programming
    Replies: 4
    Last Post: 06-17-2013, 02:04 PM
  5. Access error 2074 - transactions
    By John_G in forum Access
    Replies: 4
    Last Post: 11-15-2011, 12:40 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