Hyperlink to a folder

[Guest]

I have a split database deployed to several different users on Windows Server
2003. Some users link to many back ends in different file locations.

My problem is with a Hyperlink form. When a hyperlink is created by "User
1" from "User 1" location, the hyperlink works perfectly. When "User 2"
links to "User 1" backend from "User 2" location, the hyperlink no longer
works.

Does anyone have code that can automatically update a hyperlink path based
on the user location or login?

 

[Guest]

Kathy,

You'll need to setup your db to save the UNC path and not the user's mapped
drive.

take a look at:
http://www.mvps.org/access/api/api0003.htm

You'll need to catch the dir/filename before it gets saved and change the
drive letter to a UNC path for your network.