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

  • Thread starter Thread starter Marc Vissers
  • Start date Start date
M

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
 
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.
 
Back
Top