Hyperlink pointing to 2-Drives

[Susan via AccessMonster.com]

I have an email routine in access that sends an email notification to the
user. In this notification is a link which takes the user to the Access
database. The problem that I am having is that some users are on the G:drive
and some are on the K:drive. The path is the same but the drives are named
different.

Is there a way to make sure both groups can find the path G: and K:? Here’s
my code:

DoCmd.SendObject acSendNoObject, , , frmActive.AssignedTo.Column(1), , , "
Issue Tracking No: " & frmActive.TrackingNo & "", "YOU HAVE AN ISSUE TO
RESOLVE. Please go to the Tool and resolve within 3-days. THANK YOU! -
Assigned Date: " & frmActive.AssignedDate & " file:///G:\Field%20Shared\My%
20Accounts\Issue%20Tracking%20Tool\Tools.mdb""""""", False


Thanks,
Susan

 

[Ron Weiner]

You can try using a UNC instead of a mapped Drive

file://Server\Share\RestofPathToFile\FileName.mdb

If all of the users have rights to the share you should be OK.

 

[Susan via AccessMonster.com]

Work Great!! Thanks Ron..........

Susan

You can try using a UNC instead of a mapped Drive

file://Server\Share\RestofPathToFile\FileName.mdb

If all of the users have rights to the share you should be OK.

I have an email routine in access that sends an email notification to the
user. In this notification is a link which takes the user to the Access

[quoted text clipped - 3 lines]

Is there a way to make sure both groups can find the path G: and K:? Here's
my code:

[quoted text clipped - 6 lines]

Thanks,
Susan