Solved

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

Posted on 2008-10-15
2
448 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
2 Comments
 
LVL 9

Assisted Solution

by:borki
borki earned 250 total points
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

743 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now