viewing photos on 2 different computers

[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

 

[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

 

[Guest]

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

 

[Kamal Hood]

you guys rock! i can't believe i didn't think of this before.

thanks,
kamal

wrote in message news:e5fEnTE%[email protected]...