Photo links with 'Common Dialog API'

I

Ivan

I am creating a database to be used over a network from different computers
and it includes images linked to the form using the common dialog API.

My question is whether there is a way to make the link relative to the
database as opposed to a specific address. If Im not being clear; at the
moment the mdb is on a network drive that is mapped to this computer with
drive letter K, therefore the address to the photos are
K:\blah\blah\blah\blah.jpg If the network drive is mapped to a different
letter on a different computer the photos wont be found (I am assuming). The
photos are in a folder that shares a folder with the mdb, is there a way for
the link to let it know its next to it. I hope this is a bit clearer.
 
A

Arvin Meyer [MVP]

You can replace the mapped drive with a UNC path:

Instead of:

F:\FolderName\FileName

use:

\\ServerName\ShareName\FileName
 
I

Ivan

Thanks for replying,

When you say replace the mapped drive with a UNC path, I had thought of
that, however is there a way either Access or the Common Dialog API can do
that automatically or are you suggesting to do it manually with each link?
there will be hundreds of photos.
 
Top