Saving .rtf in an access database 
Author Message
 Saving .rtf in an access database

I remember reading something a while back about save a .rtf file into an
access database with all its formating.  I have since lost the article and
all my attempts to make this work have meet failure.  Anyone know how to
accomplish this.

Gregory La Due



Sat, 29 Dec 2001 03:00:00 GMT  
 Saving .rtf in an access database
Why don't you just save it into a memo field ?




Sat, 29 Dec 2001 03:00:00 GMT  
 Saving .rtf in an access database
Gregory,

You could use a memo field, as the other post suggests, or a Long Binary field.
The second option takes a bit more code to pull off, since you need to use the
Get/AppendChunk methods, but is faster in most cases and is less space-hungry.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please post/reply to the newsgroup(s) so
that everyone can benefit from the discussion.

Regards,

Klaus H. Probst, MCP

       ICQ: 22454937
      The VB Box: http://members.xoom.com/kprobst/
~~~~~~~~~~~~~~~~~~~~~~~~~~~



Quote:
> I remember reading something a while back about save a .rtf file into an
> access database with all its formating.  I have since lost the article and
> all my attempts to make this work have meet failure.  Anyone know how to
> accomplish this.

> Gregory La Due




Sat, 29 Dec 2001 03:00:00 GMT  
 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.



Sat, 12 Jan 2002 03:00:00 GMT  
 Saving .rtf in an access database
Update worked fine with ADO 1.5 ...

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  
 
 [ 5 post ] 

 Relevant Pages 

1. RTF save using ADO / COM to Access / SQL database

2. RTF String Save to Database via WebService

3. Save Highlighted RTF to Database

4. Save an access table to .txt and .rtf

5. Saving an Embedded Word Document to an Access Database

6. Very Slow saves with large database in MS Access 2000

7. Very slow save of objects in big Access 2000 databases

8. Save a copy of an entire access database with code

9. Utility to pick pictures into Access database and save its as file

10. Saving/Retrieving a Winword object in a Access database

11. Save as access database in MS Project 2000

12. How to save and load images to/from Access Database

 

 
Powered by phpBB® Forum Software