How can I re-establish a link to an external file?

K

Kjell

Hi,

I have linked a graph, produced in Excel (MyFile.xls), to a report in my
Access database. I have manually established the link by following
"Insert-Object-Create from file" in Report design view. When I move my Access
application to another computer, it looks like I have to re-esablish the
link, but since I'm handing out a compiled version it is not possible to open
the Report in design view. I need to re-establish this link programmatically.
How can I do this? How will the code look like?

Any help is appreciated!
Access 2002
 
Top