How to change the path of coupled OLE-objects in one table at once ?

[Marc Vissers]

I'm working with a rather big database which has data fields containing
coupled OLE-objects. Unfortunately I had to reorganize my harddisks, so the
data has moved and now Access can't find the OLE-objects anymore since the
path has changed. How could I change the path for all OLE-objects at once
without too much hassle ?
Thanks very much in advance.

Marc

 

[John Nurick]

Hi Marc,

AFAIK you can't do this with just a query. Instead, use a
BoundObjectFrame control on a form, bound to the OLE field. Write VBA
code that navigates the form from beginning to end of the table; as far
as I can remember, for each record you need to make the appropriate
change to the SourceDoc property of the BoundObjectFrame. You may also
need to set the Action property to actually update the field.