Common address in hyperlink on shared drive
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?
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?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
"I have now set the drive that the photos and the backend database reside on as a shared drive"
- since you already put the database and picture on shared drive, you can try 2 option:
1: mapped that shared drive on all pc that need to access that shared drive. use a same mapped drive name for all such as H:\. make sure you clicked the checkbox on 'always reconnect..' and 'remember password' option if available. in your program, use H:\ as the folder to read the database and picture.
2: use //machinenameORipaddress/s
- make sure all the pc have the right previllege and access to that shared drive.
- since you already put the database and picture on shared drive, you can try 2 option:
1: mapped that shared drive on all pc that need to access that shared drive. use a same mapped drive name for all such as H:\. make sure you clicked the checkbox on 'always reconnect..' and 'remember password' option if available. in your program, use H:\ as the folder to read the database and picture.
2: use //machinenameORipaddress/s
- make sure all the pc have the right previllege and access to that shared drive.
ASKER
Sorry for the delay in responding. I thought I had closed out but forgot. i ended up using the suggestion made by Mindsuperb as it seemed to work well and easily.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Ed