Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saving a Word Document in Access 97 Using Visual Basic

Status
Not open for further replies.

nazzaro

Programmer
Jun 28, 2000
31
US
I am trying to store Word Document Objects into Access 97 ole object fields using Visual Basic.

If I try to store the document object in the appropriate field in the normal way, such as:

rcsDoc.AddNew
rcsDoc("Document") = msWord 'where msWord is a Word
document object
rcsDoc.Update

Something gets stored, identified as "Long Binary Object" rather than "Microsoft Word Document" (as is the case if 'inserted' using Access) and is inaccessible (won't open when double-clicked from Access).

Any help would be greatly appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top