I am porting a DB application from Visual FoxPro to MS Access 2007. All the data has imported correctly with the exception of an embedded object.
In the old application (under Visual FoxPro) the user was given a "open file" dialog box where several .RTF files were listed. The user would select an .RTF file and then it would be embedded in the DB as an object.
The problem is Access does not know what to do with this object. If you look at the attached code you will see where I have tried a work around. The text of the original .RTF file will display in MS Word, but it has around 30 random characters at the beginning.
Question: How do I tell Access to treat this embedded object as an MS Word object?
Private Sub part_number_DblClick(Cancel As Integer)
Open "E:\MyDir\OleOut.rtf" For Binary Access Write As #1
Put #1, , Me.doc_content.Value
Call Shell("WinWord E:\MyDir\OleOut.rtf")