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

Andrew Donnelly

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

Subscribe Reply

2253

David Schofield

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

Similar topics

3947

Build Error for ASP.Net app - "could not find file... 'Interface not registered'"

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 the setup project. Could not find file 'C;\Web\ccsm\ccsm_search.aspx' 'Interface not registered' Thie file is included in the project, so I am...

.NET Framework

3725

Error w/user control "could not reformat..."

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 HTML is this: <uc1:_Header id=_Header1 runat="server"></uc1:_Header></TD></TR> Any ideas?

ASP.NET

7900

Ms Access database error."Could not update.Currently Locked"

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 Access database, I update a text type datafield of that record in Access database to 'Y' (to mark the perticular record as a copied record)(The program...

Microsoft Access / VBA

2532

"Could not read memory" error

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 shuts down? Do I need to do something special with data execution prevention? What's wrong?

ASP.NET

5570

"This is often an indication that other memory is corrupt." Error. Any clues?

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 indication that other memory is corrupt." Googling this seems to turn up a random assortment of potential causes. What is odd is that in our...

ASP.NET

6478

Using "this" and "window.event.srcElement" in IE

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 event listener to an element to change its border on mouseover and mouseout. I don't want to use CSS to do this (long story). The problem is that...

Javascript

5885

"Error: Could not find a match for" is the bane of my existence right now

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 matter what modifications I make, I get an error, "line 42: Error: Could not find a match for std::basic_istream<char,...

C / C++

4187

Postgres "could not write to hash-join temporary file"

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 drives. Does anyone know what might be causing this?

PostgreSQL Database

2280

using Domino in .Net1.1 - error "Could not open the ID file"

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: Could not open the ID file Error Source: NotesSession Error Stack: at Domino.NotesSessionClass.Initialize(String pPassword) at...

.NET Framework

4901

Webclient UploadFile "could not find file c:\..."

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 and the file is copied from the server to the server, rather than from the web client to the server. Please help!!!

ASP.NET

7918

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7843

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

8206

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7967

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

8220

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

5392

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3875

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2353

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1452

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP