Error in updating memo field

From: S N (uandme72_at_yahoo.com)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 21:19:24 +0530

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.

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.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)
  • 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.data.ado)