Displaying IMages on a network

[Hammy]

I have a table that holds information on families, including an image path. My families form has an image control that sets the .picture property based on the image path for the current record. This works absolutely perfectly on the server (where the pictures are stored). However, when accessing the db from a workstation, I get the "picture not found" message, because obviously the the machine is looking for the same path on the workstation, not the server.

The only workaround I can think of is to place a directory with all the photos on each machine in the same location as on the server to have the photos displayed on workstations, however this seems like a big waste of hard drive resouces.

Does anyone have any suggestions how I can keep my current configuration, but have the photos displayed from the server when using the db from a workstation? I need this to work, becuase I also have a "Member Directory" report that includes the families photos, and with this bug, it would only properly print from the server.

Thanks,
Hammy

 

[sambo]

Place the images in the same network folder as your .mdb
To get the network path, use this..

Dim loc As String, str As String, imgDir As String

loc = Application.CurrentProject.Path 'retrieve project path
str = "\picDirectory" 'get your image directory
imgDir = loc + str


Now you've got a shared image directory.
I'll warn you though, downloading the images from the network will be slower than storing them on each local machine. You might think about creating an installation (setup) file that automatically creates a directory on each user's local machine which holds all the images. Then you could hard code the reference to something like "C:\yourProj\picDirectory". If you use this method, then you can store templates, pictures, and all kinds of other doo-dads on each user's local machine. If you do the installation file correctly, they will never even know.

Good Luck..

 

[Hammy]

I agree, however it is for a church membership, so the photos will be constantly changing and increasing. To store them on each machine would require updates to all machiens when these changes take place.

 

[sambo]

Good point