Changing OLE Links

[Guest]

Hi MSDNers,

I am trying to change the link (i.e. source) of a linked OLE object in my
Access form in VBA, but have had little sucess after Googling for many hours.
I have tried changing the property, "SourceDoc", for an unbound OLE obect,
but this does not appear to be how OLE objects locate the data.

Can anyone help?

Thanks in advance,
Mat

 

[John Nurick]

Hi Mat,

When you say "a linked OLE object", do you mean you have a table that
has an OLE field in which you have stored linked objects? If so, I think
you need to use a form bound to the table, with a BoundObjectFrame
control bound to the field. You can then use VBA code to manipulate the
BoundObjectFrame and through it the object.

 

[Guest]

Hi John,

No, this was NOT what I meant... I am looking to link an OLE object EXTERNAL
to the database, I.E. stored on disk. (eg. C:/A Document.doc)

Thanks,
Mat