Bound Object Frame

[Guest]

I have a database that uses a bound object frame, I want to use the path of
the object frame to paste the picture in to excel, but when I write
myimage.sourcedoc it allways has an empty string.

I would like to know how can i display the path for a bound object frame?

Thanks

 

[Stephen Lebans]

Access does not expose this information.
Have a look here for a workaround, specifically the Inventory function:
http://www.lebans.com/oletodisk.htm
NEW - Feb 06/2006 ExtractInventoryOLE.zip A2K or higher ONLY! This
version saves the entire contents of a table containing OLE Objects to disk.
Does NOT require the original application that served as the OLE server to
insert the object. Supports all MS Office documents, PDF, All images
inserted by MS Photo Editor, MS Paint, and Paint Shop Pro. Also supports
extraction of PACKAGE class including original Filename. Contains function
to produce a full Inventory of the OLE field including LINKED path and
Filenames. Uses Structured Storage API's to read the actual contents of the
field. Version BETA 1.56

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.