473,287 Members | 1,580 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Issues with updated Memp by SQL code. Keepo getting Error msg "Could not update; Currently Locked by session on this machine"

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 have to click the continue button. Once the button is click
then, there is some VB code that uses SQL Update to take the
information on the form and update the table with the new changes.
However, I am having issues with the Memo fields. I have looked at
several different posts and have not been able to come up with a
solution. Can anyone offer any info at all?? The VB error code is
3188.

Cheers
Nov 13 '05 #1
1 2224
On 10 Mar 2005 10:13:54 -0800, An*************@Shell.com (Andrew
Donnelly) wrote:
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 have to click the continue button. Once the button is click
then, there is some VB code that uses SQL Update to take the
information on the form and update the table with the new changes.
However, I am having issues with the Memo fields. I have looked at
several different posts and have not been able to come up with a
solution. Can anyone offer any info at all?? The VB error code is
3188.

Cheers

Hi
there is a long history of posts with this error without any responses
giving a clear summary of the anwer(s), at least that I can find. The
error comes up only when the memo field is 2000-whatever in size or
larger. Answers usually concentrate on the field being bound in some
way to a form or control but I think it can occur also just as a bug
in Access, going back to A97.
If the field really is unbound, rather than using SQL have you tried
running the update by using AppendChunk in DAO? Code is fiddly but
there are examples in the A97 help file for example.
David


Nov 13 '05 #2

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

Similar topics

3
by: Brian Fulford | last post by:
I am trying to deploy a web app with a deployment project since I am including Crystal Reports for .Net. I attached all the merge modules, etc but I am getting a build error when I try to build...
2
by: VB Programmer | last post by:
I created a simple user control and placed it on another page. Often I get this error: "Could not reformat the document due to line 27. The original format was restored." Line 27 in the...
1
by: amindi | last post by:
Hi, I wrote a VB6 program to read some data records from a Ms Access database and to write them into a SQL server database.(I use Ms Access 2000 and SQL server 2000).After reading each record in...
3
by: news.microsoft.com | last post by:
Who knows what it means when a Windows XP Pro SP2 produces a transient error window from aspnet_state.exe saying "instruction at reference to memory at . memory could not be read." every time it...
5
by: darrel | last post by:
We're getting this error on a page that uses a particular User Control we created: "An Error has Occured retrieving the news item. Attempted to read or write protected memory. This is often an...
5
by: anEchteTrilingue | last post by:
Hi everybody. Thank you for reading my post. I am having trouble getting "this" to work in all versions of IE (it's fine in Firefox, opera, konqueror, etc). What I would like to do is add an...
2
by: Sejoro | last post by:
Hello, I am trying to write a program that opens a file; reads through it; outputs the text; then outputs the number of lines, words, and characters. Problem is, every time I try to compile, no...
0
by: rangi500 | last post by:
Hello, We've recently started getting errors like this: Last error: ERROR: could not write to hash-join temporary file: No space left on device But there is plenty of space on the all the...
0
by: =?Utf-8?B?eHl6X2phdA==?= | last post by:
I have a winodws service which sends email using Domino. The service is installed using System Account but it is not able to send emails and gives following error - Error Message: Notes error:...
6
by: =?Utf-8?B?U2NvdHQgVHJpY2s=?= | last post by:
I followed the instructions from MSDN for Webclient UploadFile and I get an error: Could not find file 'C:\testfile.xls'. If I add the file (c:\testfile.xls) to the server I do not get the error...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...

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.