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

[mz]

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?

[mz]

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?

[Ron Paii]

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

[mz]

Thank you, I never use MultiValue feature.

[Ron Paii]

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.