469,601 Members | 2,344 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,601 developers. It's quick & easy.

Extracting embedded OLE documents from Access

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.
Nov 13 '05 #1
2 2451
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.
Nov 13 '05 #2
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.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Nadav | last post: by
reply views Thread by SAL | last post: by
2 posts views Thread by chris_j_adams | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.