Creating Link object Question

[Guest]

Are the links absolute or relative links between the Ole Object being link to
and where I am putting the linked object?

What I means, If I have a folder with an excel spreadsheet, and in this
folder is a Access table too. When I link the excel drawing into my access
table using Linked object, will the link break when I move the folder from
one location to another???

If the link is broken, is there a way to have relative links where the link
remains connected because the relative location is the same except the folder
has been moved with both applicatons still at the same relative location?

Thank You,

Gary

 

[John Spencer]

Links are "absolute".

You can use VBA to build a link path and reset it.

 

[Guest]

How would I add a Link object (visio) into a table entry??

I have a table field that is OLE Object. Would I need to create a form with
an unbound or bound object frame and use VBA code to change the SourceDoc,
and set Action = acOLECreateLink???

I tried "How to Programmatically Link or Embed an Object on a From" Article
#209990 and it didn't add the link within my table. I see the frame taking
on the new files that I was linking, but it didn't add to the table.

Can Someone help??

Gary