I have set up a form that has a button to allow users to attach a link to a photo. The code for the button is:
It works well for the machine that contains the picture. I have now set the drive that the photos and the backend database reside on as a shared drive. I then loaded the Front end on another PC. The program works fine but when I double-click on a photo from the remote machine it won't open, presumably because the reference is to a place on a local drive. Does anyone have any suggestions on how to set it up so that the reference works irrespective of what machine it is loaded on?