Memo Field Update Problem ADO JET 
Author Message
 Memo Field Update Problem ADO JET

I have a hard time updating a Memo field in an Access (.Mdb) database.

When I do "recordset.Update" with any other field on the same database,
the update is properly propagated physically to the database.

However, when I do recordset.field("TheMemoField").Value
= "TestString",
the new field value is shown OK, but when I do
"recordset.Update", the new value is lost?
Even if I do recordset.update(vFieldName, vFieldValue), the new value
is not stored
on the database...

Should the new string value be null-terminated, or something?

ADO reports the field type as adLongVarChar(201) - Long String Value.

Using:
Microsoft Jet (Access 7.0 .Mdb)
Microsoft Visual Basic 5.0 Professional (Sp2)
ADO 2.1, through Microsoft Data Access Components 2.1(MDAC
2.1.1.3711.11)

Thank you for any help.

--
Dan.

Sent via Deja.com http://www.***.com/
Share what you know. Learn what you don't.



Sat, 12 Jan 2002 03:00:00 GMT
 Memo Field Update Problem ADO JET


Quote:

> Use the INSERT INTO sql statement.

db.execute "INSERT INTO TestTable ([TheMemoField])
VALUES('" & TestString & "')"

I have a hard time updating a Memo field in an Access (.Mdb)
database.

Quote:

> When I do "recordset.Update" with any other field on the same
database,
> the update is properly propagated physically to the database.

> However, when I do recordset.field("TheMemoField").Value
> = "TestString",
> the new field value is shown OK, but when I do
> "recordset.Update", the new value is lost?
> Even if I do recordset.update(vFieldName, vFieldValue), the new value
> is not stored
> on the database...

> Should the new string value be null-terminated, or something?

> ADO reports the field type as adLongVarChar(201) - Long String Value.

> Using:
> Microsoft Jet (Access 7.0 .Mdb)
> Microsoft Visual Basic 5.0 Professional (Sp2)
> ADO 2.1, through Microsoft Data Access Components 2.1(MDAC
> 2.1.1.3711.11)

> Thank you for any help.

> --
> Dan.

> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.


Mon, 14 Jan 2002 03:00:00 GMT
 Memo Field Update Problem ADO JET
This is a bug in OLE DB Provider for Jet 3.51, there is a description
and, most important, a solution in Microsoft Support Article ID:
Q198532.

It works fine with Jet 4.00 OLE DB provider.

Thanks.
Dan

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.



Mon, 14 Jan 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Problem with Memo field in Jet 2.5 Parameter Query

2. Updating Memo Fields in MS Access using ADO Parameter / Stored Procedures

3. ADO Update (using VB) of Memo fields in Access 97 DB

4. Unable to update memo field in Access2002 with ADO

5. ADO/SQL - Updating large memo field

6. Weird error updating fields with ADO 2.6 Jet 4.0 SP5

7. ADO Update of Memo Fields

8. ADO, Access, Memo-Field update error at size above 64K

9. local SQL: memo field update problem

10. Problem opening recordset for update ADO 2.1/Jet 4.0/Access 2000 stored proc

11. Problem opening recordset for update ADO 2.1/Jet 4.0/Access 2000 stored proc

12. insert/update problems with memo fields


 
Powered by phpBB® Forum Software