Can anyone help me with a problem I have with OLE objects.

I am developing an application which includes a number of video clips. While I've been working on it, I've realised that if I move a video clip after I've embedded it into a form, the next time the form is opened, you have to navigate to the new location of the video clip.

The application is intended for a local network so this issue doesn't present a problem here. However, the application is also intended to be burnt onto CD so it can be distributed to PCs which have Access97 installed. I thought that embedding the video clip would ensure that it didn't matter where the orginal avi ended up (much like an embedded image).

Is there any way I can get round this problem? As far as I can see it, the only way round it would be to create the forms with the avi clips embedded pointing to a location on the hardisk. Then when the CD is distributed, have those avi files copied to the same location on the PC's hardisk that runs it.

Is there something that I'm missing which will enable me to embed the entire contents of the avi clip into the form or is the only other solution purchasing a copy of the Access97 Developers Edition CD?

Many thanks,

Carl