Displaying RTF Document after writing Blob File

hturk

New member
Local time
Today, 13:12
Joined
Sep 18, 2007
Messages
1
I am using the functions that are displayed in the knowledge base article 103257 ACC: Reading, Storing, & Writing Binary Large Objects

My Code read as follows:

Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim strSQL As String
On Error GoTo Err_cmdDisplayAttach_Click

strSQL = "Select dbo_Attachment.* From dbo_Attachment Inner Join tmpAttachment "
strSQL = strSQL & "On tmpAttachment.AttachmentID = dbo_Attachment.AttachmentID "
strSQL = strSQL & "Where AttachSelected = true"
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset(strSQL)
Do Until rst.EOF
retval = Shell(Environ$("ComSpec") & " /c""" & rst("HyperlinkPath") & """", 0)
rst.MoveNext
Loop

Works fine with reading and writing blob data to an sql table for every picture, application, etc.
The only application that will not render properly is an rtf document. It will not display in ms word.

I tried WordPad and it displays blank.

I tried adobe and I get a permission error.

Could someone possible steer me in the proper direction? I am not sure if there is something in the header of
The rtf document that needs to be saved or if there is a property that needs to be saved in addition to the BLOB.

Thanks
Harry
 

Users who are viewing this thread

Back
Top Bottom