Photo links with 'Common Dialog API'

[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.

 

[Arvin Meyer [MVP]]

You can replace the mapped drive with a UNC path:

Instead of:

F:\FolderName\FileName

use:

\\ServerName\ShareName\FileName

 

[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.

 

[Daniel Pineault]

Use the following code to automatically convert the mapped drive to the UNC
as per Arvin's suggestion.

http://www.mvps.org/access/api/api0003.htm
--
Hope this helps,

Daniel Pineault

 

[Ivan]

Thankyou,

I appreciate your help.

Ivan

Use the following code to automatically convert the mapped drive to the UNC
as per Arvin's suggestion.

http://www.mvps.org/access/api/api0003.htm