Hi,
We have a table (DOCUMENT) with column (DOCLINK) of type OLE Object. This column stores an image, which is NOT embedded BUT is linked.
Now the servername has changed where the original images were picked from.
Can someone tell how we can write a VBA program/query to update the OLE Object column so that the links point to the new servername.
Assuming the links are UNC paths.
Note the links are stored in OLE Object type column and not in a char/varchar.
Many thanks in advance.
PKtechnie.
We have a table (DOCUMENT) with column (DOCLINK) of type OLE Object. This column stores an image, which is NOT embedded BUT is linked.
Now the servername has changed where the original images were picked from.
Can someone tell how we can write a VBA program/query to update the OLE Object column so that the links point to the new servername.
Assuming the links are UNC paths.
Note the links are stored in OLE Object type column and not in a char/varchar.
Many thanks in advance.
PKtechnie.