Extracting PDF files from OLE Fields

[PacketMule]

I'm trying to extract en masse 1000 PDF files out of an MS
Access 2000 db to a default directory. Using Microsoft's
instructions for Writing Blobs I succeeded in bringing
down what was in the OLE fields.
2 Problems: First, I don't have a seperate field that
holds the filename (that has to be extracted from the OLE
field information somehow), and second, the file is
unusable because Adobe says, "...it is not supported or
has been corrupted...".
I'm assuming that there has to be some sort of filter I
have to push the binary data through to have it come out
as a PDF.
Any ideas? Much Thanks.

 

[John Nurick]

Hi Mule,

Probably what's in each OLE field is not a PDF file but an OLE object
containing a file (along with information about the parent application
and so on). The only remotely easy way I know of getting these back into
files is to use a form with an ObjectFrame control bound to the field:
you have to iterate through the recordset and for each record activate
the object in its parent application (using the Verb and Action
properties of the ObjectFrame) and then save it to disk.