
Saving .rtf in an access database
Quote:
> Why don't you just save it into a memo field ?
I once did that, worked fine. Lately, though, I'm experiencing problems
with ADO and Jet memo fields: I can't get the database to be updated!
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.
--
Daniel Pelletier
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.