By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 614 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

Extracting embedded OLE documents from Access

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.