Link filename to jpg file in directory/Not relative to drive mapping

[diana1]

Using: Access 97

1. Link Filename to jpg for display:

I have a list of products, associated with filenames of jpg photos. I have all photos in a single directory. Some products have more than one jpg file, and I'm using continuous forms. Most jpg files are linked to many products.

How do I link the jpg's actual filename that is associated with the product so that the picture shows up in the form?

2. Relative location of jpg files:

Also, I have the dB saved on the server, and will be used by many others. The bound objects seem to link through a mapped drive relative to my desktop. If the solution to my first problem is bound objects, how do I bind the object relative to the jpg directory on the server, rather than a pathway from the user's desktop?

Thanks in advance for your kind help!
-Diana

 

[smedvid]

Well ... my one suggesting is to use UNC for path/file name references. Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/