troubleshooting Question

Common address in hyperlink on shared drive

Avatar of Rob4077
Rob4077Flag for Australia asked on
Microsoft Access
4 Comments1 Solution281 ViewsLast Modified:
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:
CarPicture1.SetFocus
DoCmd.RunCommand acCmdInsertHyperlink

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?
ASKER CERTIFIED SOLUTION
MINDSUPERB

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros