[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

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

Posted on 2004-10-28
8
Medium Priority
?
544 Views
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.
0
Comment
Question by:niblick
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 27

Accepted Solution

by:
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

Jaffer
0
 
LVL 34

Expert Comment

by:flavo
ID: 12433388
2k??? Dont they hold 64k charaters???
0
 
LVL 5

Author Comment

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

jjafferr,
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!
nib
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
LVL 5

Author Comment

by:niblick
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.
0
 
LVL 5

Author Comment

by:niblick
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.
0
 
LVL 27

Expert Comment

by:jjafferr
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.

jaffer
0
 

Expert Comment

by:ajg23
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...
0
 

Expert Comment

by:ajg23
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!)
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Suggested Courses

640 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