Hi Richard
My table consists of a few populated text fields and 2 blank OLE Object fields.

For the last 2 days I have been creating the OLE Objects as follows :

Initially I select Tables from the Objects list, and then from the Datasheet view
I click on the appropriate {blank} field, and then click on the following path :

Insert > Object > Create from file > Browse > ( Locate file from my PC) > Link > OK

I can then click on the newly populated field, and “see” the correct file OK.

My problem is that I now need to make the db available to colleagues,
but my linked files are located in my PC’s C drive.

So if my PC isn’t powered up, this will not work.

I can copy these linked files from my PC to a shared network drive,
but is there any way to trick the db not to look to my C: drive, but to the new shared address ?

Or will I have to re-enter all the links, as a punishment for my lack of foresight ?

Many thanks

---

Answer from Richard Rost:

Yes, unfortunately without some programming you are going to have to reestablish all of your links. You could write a program to loop through all of the records and using VBA code change those links, but that might take more time than just re-inputing the data (depending on how many links you have). Sorry I can't offer a better solution for you. ALWAYS use UNC paths like //JoesPC/C/Files/filename.jpg when making links like this.