Search code examples
ms-accessms-access-forms

MS Access Error 3188: Could not update; currently locked by another session on this machine

I have a form bound to a table with a long text field (form_conversationDetail).

I can add and then edit and save the same record until the number of characters in the field goes over 2000.

After that, I start getting the following when I attempt to save the record:

Error 3188: Could not update; currently locked by another session on this machine.

I have a parent form (form_conversations) that provides a list of records that allow the user to choose which conversation to edit in form_conversationDetail.

Before opening form_conversationDetail, I tried setting Dirty to False.

Solution

  • I added the following statement right before I save which seems to have resolved the situation:

    DBEngine.Idle dbFreeLocks