Hyperlink Relative or not?

  • Thread starter Thread starter Nite2wing
  • Start date Start date
N

Nite2wing

Hi - I have a database for Contract administration. I have setup a hyperlink
that connects to an image of the contract file. I set it up as a "relative"
hyperlink and have found that some staff can access it and some can't. When I
switch to a full url hyperlink then everyone can access it. The files are
located on a subfolder from the database folder - permissions are the same.
Initially I thought it might be the difference between using a mapped drive or
connecting via url. That doesn't appear to be the case. Any ideas?

Thanks,
Fred
 
Access keeps track of relative paths based on the current working directory
of the file that is open. If you open an Access file from the Open command
within Access, the working directory will be that directory. If you double
click on the file from windows explorer, the default Access working
directory will be used. This is the default directory in the Options under
Access. If you refer to a picture using this relative path it will find it
if you opened the database from Access, it will not if you double-clicked.
Access has a property "Application.currentproject.path" that stores the path
of the current database. This property contains the full path. You can
make sure your references images always open by defining the location of the
file as "Application.currentproject.path"&"\"&[pathRelative]. Good luck.

Kelvin
 
Back
Top