Working with images from a network
Posted on 2004-09-06
Hi, I have an Access 2002 database that I am trying to add an Image Library to. The images are jpg's, pdf's or gif's...no bmp's. I do not want to store them in my database, I simply want to give the user access to the images that are already stored on our company's network drive and the ability to see the image and possibly print the image.
As background info, I have a table that houses specific information about the image such as a response code field. The image is named as the response code - Description. (i.e. - my table might have the response code field as being "T81" and the image on the network is called "T81 - Something Something".
I'm thinking that there are two ways to go about this...one - only displaying the images of the response codes that exist on the other table (which is very limiting and many images may not exist on the network for these) or just keeping my Image Library as it's own little application on my database in which it displays each image on the network, which can get very large (at least 200 images there now). I think for this to work, I would have to be able to cut down the title of the image based on just the response code part of the naming convention and allow users to search based on that response code.
Which would be the best way to go and should I use the linked image object or the OLE object?