viewing photos on 2 different computers

K

Kamal Hood

I've created a membership db which shows photographs of members as you
scroll through their records. I don't store the photographs in the database
as this would make it much too large, I just store the directory that the
photos are in.

So, an example field record could be:
[tblMembers].[imgPath]="C:\Photos\John Doe.jpg"

Things work great but now there are 2 computers and the 2nd one cannot
display the photos--it is trying to find them on it's C: drive but the
photos are on the C: drive of computer #1. How can I get around this? I
remember way back when creating the db that I had trouble trying to use
relative image paths, so I had to hard code the paths to the C: drive.

We've thought about buying an external drive and mapping the same drive name
to it on both computers. Any other suggestions puleease?

thanks guys,
kamal
 
T

Tom

Hi Kamal

We had a simimilar issue and resolved it by using the data holding pc's UNC
address for the ImagePath statement i.e instead of C:\Photo to use \\Network
name of computer1\Photos

Tom
 
S

Sanjeev

Hi Kamal,

Instead of defining the path as c:\Photos\John Doe.jpg use UNC i.e use name
such as \\Computer_Name\Share_name_Photograph_Dir\John Doe.jpg

Sanjeev
 
Top