Re: Error in updating memo field

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 13:30:44 -0400

S N wrote:
> I have an access table with fields including a Memo field. When I try
> to update that table using ASP page (using OLEDB for ODBC driver) the
> record after the update command is updated alright. But the memo
> field in the recordset after updation does not contain the value from
> the record just updated. It contains value of memo field of some
> other record.
> The values of the fields other than the memo field in the recordset
> are displayed alright.
> This error goes away when I use Jet4.0 OLEDB driver.
>
> Please explain if this is the correct solution to the problem. I dont
> think OLEDB from ODBC is so error prone. Please tell if I am also
> committing some other error.

Are you using a SQL UPDATE statement (recommended)? or a recordset (ughh!)

Give us some details: table structure, primary key

Bob Barrows 

-- 
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Relevant Pages

  • Re: Error in updating memo field
    ... > I have an access table with fields including a Memo field. ... > are displayed alright. ... > This error goes away when I use Jet4.0 OLEDB driver. ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Inserting/Updating Access memo fields using OleDB
    ... separate them into different segments. ... > one of my fields is a memo field. ... > that I have to use OleDB to connect to the Access database. ...
    (microsoft.public.dotnet.languages.csharp)
  • Error in updating memo field
    ... I have an access table with fields including a Memo field. ... update that table using ASP page (using OLEDB for ODBC driver) the record ... displayed alright. ... This error goes away when I use Jet4.0 OLEDB driver. ...
    (microsoft.public.data.ado)
  • Error in updating memo field
    ... I have an access table with fields including a Memo field. ... update that table using ASP page (using OLEDB for ODBC driver) the record ... displayed alright. ... This error goes away when I use Jet4.0 OLEDB driver. ...
    (microsoft.public.inetserver.asp.db)
  • Error in updating memo field
    ... I have an access table with fields including a Memo field. ... update that table using ASP page (using OLEDB for ODBC driver) the record ... displayed alright. ... This error goes away when I use Jet4.0 OLEDB driver. ...
    (microsoft.public.inetserver.asp.general)