Extracting embedded OLE documents from Access

[Chris Belcher]

First some background...
The database tracks Action Items assigned to a group of 20 or so
managers. Once the assignment is created it is then emailed to each of
the managers that are included in the scope of the assignment. Among the
functions that it provides is the ability to embed the source documents
in the database using OLE. The user has requested the ability to forward
the source document with the email. The embedded documents consist of
spreadsheets, RTF, Text, and an occasional PDF. Rarely, if ever, will
the document contain complex graphics.

Since deployment has just taken place and the volume of documents that
are created is low I still have the ability to convert these documents
to linked documents if necessary. Linked documents would not be my first
choice as the user then has the ability to accidentally delete the
source document. I had thought of, on insertion, copying the source
document to a special folder but that creates a new level of complexity
that I'd hoped to avoid.

My research into this has yielded few references to extracting embedded
OLE documents. Could someone point me to a source for information on
extracting embedded objects.

I welcome thoughts, opinions, suggestions, and pointers to sources for
further research.

Thanks,
Chris

BTW.. The database will, when fully loaded, contain fewer than 300 records.

[Tom van Stiphout]

I recently wrote this code. Microsoft knowledgebase articles Q170531 and
Q114124 were helpful.
-Tom.
"Chris Belcher" <ch******@bellsouth.net> wrote in message
news:MU************@bignews5.bellsouth.net...

First some background...
The database tracks Action Items assigned to a group of 20 or so
managers. Once the assignment is created it is then emailed to each of
the managers that are included in the scope of the assignment. Among the
functions that it provides is the ability to embed the source documents
in the database using OLE. The user has requested the ability to forward
the source document with the email. The embedded documents consist of
spreadsheets, RTF, Text, and an occasional PDF. Rarely, if ever, will
the document contain complex graphics.

Since deployment has just taken place and the volume of documents that
are created is low I still have the ability to convert these documents
to linked documents if necessary. Linked documents would not be my first
choice as the user then has the ability to accidentally delete the
source document. I had thought of, on insertion, copying the source
document to a special folder but that creates a new level of complexity
that I'd hoped to avoid.

My research into this has yielded few references to extracting embedded
OLE documents. Could someone point me to a source for information on
extracting embedded objects.

I welcome thoughts, opinions, suggestions, and pointers to sources for
further research.

Thanks,
Chris

BTW.. The database will, when fully loaded, contain fewer than 300

records.

[Chris Belcher]

Tom van Stiphout wrote:

I recently wrote this code. Microsoft knowledgebase articles Q170531 and
Q114124 were helpful.
-Tom.
"Chris Belcher" <ch******@bellsouth.net> wrote in message
news:MU************@bignews5.bellsouth.net...
Thanks Tom.. I'll check it out

First some background...
The database tracks Action Items assigned to a group of 20 or so
managers. Once the assignment is created it is then emailed to each of
the managers that are included in the scope of the assignment. Among the
functions that it provides is the ability to embed the source documents
in the database using OLE. The user has requested the ability to forward
the source document with the email. The embedded documents consist of
spreadsheets, RTF, Text, and an occasional PDF. Rarely, if ever, will
the document contain complex graphics.

Since deployment has just taken place and the volume of documents that
are created is low I still have the ability to convert these documents
to linked documents if necessary. Linked documents would not be my first
choice as the user then has the ability to accidentally delete the
source document. I had thought of, on insertion, copying the source
document to a special folder but that creates a new level of complexity
that I'd hoped to avoid.

My research into this has yielded few references to extracting embedded
OLE documents. Could someone point me to a source for information on
extracting embedded objects.

I welcome thoughts, opinions, suggestions, and pointers to sources for
further research.

Thanks,
Chris

BTW.. The database will, when fully loaded, contain fewer than 300

records.