1. Forum
  2. USENET
  3. comp.databases.ms-sqlserv

  • "Could not update; currently locked by another session on this machine."

    From mz@maciej.projectmanager@gmail.com to comp.databases.ms-access on Mon Apr 12 14:12:13 2021
    From Newsgroup: comp.databases.ms-sqlserv

    Hello, I'm having this problem with macro in a sub form: "Could not update; currently locked by another session on this machine." It happens while button on click event runs macro, and in this macro I do RunDataMacro (nothing else), it is all quite simple. Yet it won't work. I've never seen this error\problem (and I playing with Access for past handful of years). I tested it on two machines, same problem. It's a single user database, with simple interface. Any idea what is causing this?
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From mz@maciej.projectmanager@gmail.com to comp.databases.ms-access on Tue Apr 13 05:03:43 2021
    From Newsgroup: comp.databases.ms-sqlserv

    EDIT: it is Data Action - Set Field producing this exception, it is triggered by the form button on click event with RunDataMacro which in the end does Set Field etc. It appears that Set Field works with any table field in that table except long text field type (the problem). It is not working even with form's: Record Locks set to No Locks, Allow Edits is set to Yes ... So my question is: are there functionality limitations with Data Action - Set Field run on Long Text fields?
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Ron Paii@ron81pai@gmail.com to comp.databases.ms-access on Tue Apr 13 05:43:23 2021
    From Newsgroup: comp.databases.ms-sqlserv

    I ran into that problem in 2020
    Disable MultiValue fields in the tables https://support.microsoft.com/en-us/office/create-or-delete-a-multivalued-field-7c2fd644-3771-48e4-b6dc-6de9bebbec31
    On Tuesday, April 13, 2021 at 7:03:48 AM UTC-5, mz wrote:
    EDIT: it is Data Action - Set Field producing this exception, it is triggered by the form button on click event with RunDataMacro which in the end does Set Field etc. It appears that Set Field works with any table field in that table except long text field type (the problem). It is not working even with form's: Record Locks set to No Locks, Allow Edits is set to Yes ... So my question is: are there functionality limitations with Data Action - Set Field run on Long Text fields?
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From mz@maciej.projectmanager@gmail.com to comp.databases.ms-access on Tue Apr 13 14:32:53 2021
    From Newsgroup: comp.databases.ms-sqlserv

    Thank you, I never use MultiValue feature.
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Ron Paii@ron81pai@gmail.com to comp.databases.ms-access on Wed Apr 14 05:18:49 2021
    From Newsgroup: comp.databases.ms-sqlserv

    I never used them either, but somehow a few of my tables had them and in late 2020 a Microsoft patch start causing the problem. Take a look at the tables involved to see if one of the fields is using MultiValue.

    On Tuesday, April 13, 2021 at 4:32:55 PM UTC-5, mz wrote:
    Thank you, I never use MultiValue feature.
    --- Synchronet 3.21d-Linux NewsLink 1.2