Solved

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

Posted on 2008-10-15
2
454 Views
Last Modified: 2013-11-28
Very stange problem. I have 2 forms in a database in a fron-end / back-end scenario. I'm the only one using the database. Form A and Form B. Form A does not allow editing. I have a button (made using the wizard) that opens the same record in Form B for editing. When I change something in a memo field of a CERTAIN record (not all records) in Form B, I'm unable to save the changes and get the error: Could not update; currently locked by another session on this machine

I've done a fair amount of messing around already. Here's what I've done so far:

1. Repaired and compacted both DBs. (didn't help.)
2. Read this post and tried several things (none of which led me to a solution): http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21580646.html?qid=21580646

I've Never seen this before and these forms are NOT doing anything beyond what Access creates with it's Wizards. Everything is generic as can be. No special code, nothing.

Ideas?

Thanks in advance.
0
Comment
Question by:bandriese
[X]
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
2 Comments
 
LVL 9

Assisted Solution

by:borki
borki earned 250 total points
ID: 22729396
Haven't got a solution as you already tried to solve this. Other things to consider:

What version of Access, I have found 2007 behaving strangely. I am thinking of some sort of memory corruption when you write in the memo field, so Access thinks another process has got into the field.

Have you got the latest service pack?

Have you tried to perform the same action on another PC?

Front and Back on the same PC? If not what is the network connection?

Good luck

Felix
0
 
LVL 3

Accepted Solution

by:
bandriese earned 0 total points
ID: 22735731
Access 2003, all latest patches and service packs. Same problem happends on multiple computers. Not an issue with the network. I did figure out that if I removed several lines for the memo field, then everything worked fine. the problem seems to be related to how much content is in the memo field. In this case, maybe a page worth of text and html tags. Well, don't know the cause, but I geuss I found my own solution.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

749 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