changing path for a bound object

[Guest]

I have an ole object field which contains linked images that are stored in an
image folder on my shared drive. I would link to move some the images to
dvd, how can I change the path so that instead of looking for the image in
the folder on the c drive it looks in the dvd drive?

 

[Larry Linson]

I guess you'd change the path so it refers to the DVD drive, but you'll need
to be careful to load the proper DVD when you run your database.

Larry Linson
Microsoft Access MVP

 

[Guest]

I'm not sure how to do that, I could not find the path listed in the
properties of the linked objects to change the links.

 

[Stephen Lebans]

While the OLE Interface does support the updating of Linked file
information, Access does not expose a mechanism to do so. A simple solution
would be to reinsert the desired images programmatically. There is code in
the MS KB showing you how to accomplish this.

But if you are merely linking your Images then I would suggest you stop
using an OLE field altogether. Instead use the standard Image control,
settting its Picture property in your form's Current event or in the Print
event of the relevant section in your report. In this manner the images are
connection info are maintained externally and easily modified. Larry has a
sample MBD on his site showing you the difference between these two
approached to displaying Images within an Access Form/Report.

--

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