472,328 Members | 1,029 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

home > topics > microsoft access / vba > questions > could not update; currently locked by another session on this machine

Join Bytes to post your question to a community of 472,328 software developers and data experts.

could not update; currently locked by another session on this machine

Working in Access 2000:

I have found several posts for this error message in various forums
across the internet, but no answers. Can anyone explain why this
happens?

It only seems to occur when the record contains a memo field with >
2000 characters in it.

I have tried repairing, compacting, rebuilding, and copying by
datasets too and from other databases. Nothing seems to work.

Even if someone told me this was a known, unfixed,
you-have-to-live-with-it, bug I would be happy.

Thanks.
Nov 13 '05 #1
0 1356
New Post

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
Issues with updated Memp by SQL code. Keepo getting Error msg "Could not update; Currently Locked by session on this machine"
by: Andrew Donnelly | last post by:
I am trying to update a memo field in a table from a form that I have created. The form is unbound, and once the user makes their changes, they...
Microsoft Access / VBA
3
Err 3188: Couldn't Update; currently locked by another session
by: David W. Fenton | last post by:
A very old app of mine that's been in production use, and largely unchanged since about 1998 has started recently throwing error 3188 (can't...
Microsoft Access / VBA
1
Could not update; currently locked by another session on this machine.
by: Mark Reed | last post by:
Hi All, I'm having a problem with the following code. I've read quite a lot of old posts regarding the issue but none seem to affer a solution. ...
Microsoft Access / VBA
1
-2147217887 Could not update; Currently Locked
by: StephenWeiss | last post by:
Have a vb6 program that was connecting to an Access 97 database. We have converted the database to Access 2003 and changed the provider to use Jet...
Microsoft Access / VBA
2
VB6/MS Access point of sale application problem "could not update; currently locked"
by: CWogksch | last post by:
Hello, Everyone... My name is Chris Wogksch. I have a point of sale application developed in VB6 using MS Access 2003 as the database. I've been...
Microsoft Access / VBA
0
Could not update; currently locked by another session on this machine
by: Access Programming only with macros, no code | last post by:
ERROR MESSAGE: Could not update; currently locked by another session on this machine. BACKGROUND I have the following objects: Table1 - HO...
Microsoft Access / VBA
2
Error => Could not save; currently locked by another user.
by: mike2020 | last post by:
I am using VB 6, ADO and Access in my Apps. I have one table which has a Memo field, and while saving recordset (rs.Update), at that point I am...
Visual Basic 4 / 5 / 6
6
Access 2003 Error: 3218 Could not update; currently locked
by: stuart | last post by:
I have 2 users who ran into a problem with a data entry program (written in Access 2003). One user was keying into one of the forms when she got...
Microsoft Access / VBA
11
Error "Could not save; currently locked by another user."
by: fniles | last post by:
One of our application uses VB6 and Access97 database. Another application uses VB.NET 2005. This morning for about 15 seconds when the application...
Visual Basic .NET
0
How to Remove Duplicate Items from ComboBox in JavaFX?
by: tammygombez | last post by:
Hey fellow JavaFX developers, I'm currently working on a project that involves using a ComboBox in JavaFX, and I've run into a bit of an issue....
Java
0
The Top 5 Skills You Need in a PowerApps Developer
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
.NET Framework
0
better678
Discuss your understanding of the Java platform.
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
General
0
Benefits of Blockchain App Development for Enterprise Businesses
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
General
0
How to minimize a tool bar that shows up when in reports
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
General
0
Basic concepts of WebLogic Admin training?
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
Oracle Database
0
Hyperconverged All-in-One Streaming Engine, ushering in new age for distributed database
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
General
0
How to layout php header location with a variable as the location?
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
PHP
1
How to use http requests (Get function) to get variable value?
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
Python

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2023
About Bytes
Advertise
Terms Of Use
Privacy Policy

Sitemap

Follow us! Get the Latest Bytes Updates