Change the Paths to Linked OLE Objects

[stonehead]

Hi,
I have an old access database with thousands of linked OLE objects (images). Now my image folder was moved to another server. How could I change the path of all my linked OLE objects ? It is impossible for me to manually change one by one. Please please help.

Thank you,

 

[Remou]

What do you mean by linked objects? Thousands of linked images sounds unusual. Can you post a sample record?

 

[stonehead]

I meant linked images (.tif file). Each record has 3 fields for images: image1, image2, image3. That's why I have so many images. To be specific, my database is for property data. Each record has account# and the image fields are for the scanned deed(s). And I have a form which has OLEBound controls for me to do right click on the control->insert object ->create from file -> (cchoose on link option)

 

[Remou]

Ok. So the fields reference a path which can be updated via a query. Is this true:

Old File:

Image1: E:\Docs\Images\Deeds\DeedX1.jpg

New File:

Image1: Z:\NewSystem\Images\Deeds\DeedX1.jpg

If so:

Update tblDeeds Set Image1="Z:\NewSystem\" & Mid(Image1,8)

 

[stonehead]

The problem is in the image field, it shows the word "package" not the path & file name. Let say if I manually edit the path, I can right click on "package" -> package object -> edit package -> then a "object packager" window opens -> go to Edit menu -> command line then I'll see the whole path and file name. It looks complicated to me. I don't know how I can get to the OLE thing. Thanks for your help.

 

[Remou]

Perhaps this article is what you want?

http://support.microsoft.com/kb/311147

 

[stonehead]

Thanks a lot for your help. I guess that's it. I used the codes and it only works with bitmap files not the .tif I have. Weird! I'm still struggling with error 2753 (problem occur while MS Acess was communicating w/ OLE server or activeX control) at line
.Action = acOLECreateLink

Anyway, your help is greatly appreciated.