Ole Object Problems

[Karen]

In our database we have an ole field in a table that we insert images such as
excel, word and PDFs. The setting for the field is EITHER (embedded,linked).
When I look in our table now, we have Package, Imaging, Excel, Word and now
we have ARCO.EXCH.document.7 showing up and cannot seem to open these images
without an error. Some excel files cannot even be opened either. Any
suggestions as to what the problem is and how to fix it.

 

[Fred]

I noticed that nobody answered. Your question is really lots of questions,
i.e. making stored items from all of those different applications do who
knows what. You also said "images" but used it to refer to things which
aren't images.

Here's an answer to one of them. For items whihc really are images (e.g.
..jpg's) the way to do it is to store the images separately and store the path
and file name in a text field, and use code (search previous posts for "how"
) to display the image in a form or report.