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

Links are "absolute".

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


"Gary" <(E-Mail Removed)> wrote in message
news:C1DC1969-3D32-476B-94D9-(E-Mail Removed)...
> 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

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

"John Spencer" wrote:

> Links are "absolute".
>
> You can use VBA to build a link path and reset it.
>
>
> "Gary" <(E-Mail Removed)> wrote in message
> news:C1DC1969-3D32-476B-94D9-(E-Mail Removed)...
> > 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
>
>
>