• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 480
  • Last Modified:

email adobe pdf document stored in OLE Object table

I have several imported pdf documents stored in a OLE Object column.  I woul like to email them via outlook when a user clicks on a command button on a form.  I have the email code, except for how to attach the OLE Object.  I tried to write the file to a temp.pdf file, but when I receive the email the pdf is unreadable.  is there a memory stream or other object that can be used to attach to an email msg and be filled with the ole object column?
0
prumery
Asked:
prumery
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
prumery,

This is one of the reasons why most people do not store this type of data in OLE fields.
The other resaon is that it bloats the database.

See this lnk for a possible solution:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23846261.html

JeffCoachman
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now