1. Forum
  2. Usenet
  3. COMP.DATABASES.MS-ACCESS

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

    From mz@21:1/5 to All on Mon Apr 12 14:12:13 2021
    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?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From mz@21:1/5 to All on Tue Apr 13 05:03:43 2021
    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?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ron Paii@21:1/5 to All on Tue Apr 13 05:43:23 2021
    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?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From mz@21:1/5 to All on Tue Apr 13 14:32:53 2021
    Thank you, I never use MultiValue feature.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ron Paii@21:1/5 to All on Wed Apr 14 05:18:49 2021
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)