Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Could't Update; Currently Locked by Another Session on this Machine

Posted on 2004-10-28
Medium Priority
Last Modified: 2008-03-26
There were two previous posts for this question back in Dec 2002 with no resolution.

This problem exists when using a MEMO field (also tested with OLE Object field and get the same error).  The senario is that data is entered into this MEMO field.  Later the field is edited and more data added.  This continues to work until the field has around 2k worth of characters at which time an attempt is made to save the record and then the error message "Could't Update; Currently Locked by Another Session on this Machine" appears.

One work around seems to be to add another record and then come back to this record and then you can get past the 2k limit.  But then the extra record needs to be deleted.
Question by:niblick
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
LVL 27

Accepted Solution

jjafferr earned 2000 total points
ID: 12433280
Hi niblick,

I would recommend the following:
make this memo field (memo1) Unbound and it will be used for data entry,
make 2 Bound hidden memo fields,
On lost focus of the memo1, count the number of characters, and if more than 2k, then split them in both the hidden memo fields,
otherwise fill in the first hidden memo field.

On Current of the Form, make sure:
[memo1]=[memo2] & [memo3]

Hope this helps

LVL 34

Expert Comment

ID: 12433388
2k??? Dont they hold 64k charaters???

Author Comment

ID: 12433718
flavo........yes, a memo field holds 64k characters.

The field is already unbounded and I have tried to update using methods and recordsets.  I currently am not displaying the full contents of the field and only use the form field to append the data via an update to the existing data.  This has sparked an idea in my mind though, something about what was said in another thread.  Something about two forms being open.  I do not have the form opened twice but I do have the record open on two forms.   The initial display form and then the edit form.  Perhaps if I close the initial display form and reopen it after I have finished with the edit form then this might get around the locking problem.  Let me test it out and if it works I will give you the points for making me think to hard.  Ow, it hurts!

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.


Author Comment

ID: 12433753
Just a note so everyone knows why I have a display form and an 'edit' form.  The first form just displays the data.  Users cannot edit the data on this form.  The application is like a running journal where you can add comments but not edit what has already been entered.  Therefore, the second form is only used to add new comments to the existing comments field.

Author Comment

ID: 12434091
The problem seems to have been with having the other form still open and locking the record.  What I do now is close the current form before opening the 'edit' (add comments) form.  Then when I close this form I re-open the other form.

jjaffer, thanks for making me think.
LVL 27

Expert Comment

ID: 12441938
Hey I have too many other ideas, I don't mind throwing some to get you think more and throw some points at me ;o)

Thanks for the points and the grade.


Expert Comment

ID: 21218475
Dang, I have the same problem but do NOT want to close the original form (which has a list of notes from encounters). Really would love another workaround...

Expert Comment

ID: 21218660
I finally did the following workaround which I'm pretty happy with given the limitations of this Acess problem: I wound up writing a TRUNCATED version of the big memo field to the record in addition to the big memo field itself. Only the TRUNCATED version is in the query in the main list so it doesn't interfere with my EDIT form's ability to save! (The edit form saves a truncated version after the main version!)

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question