Image path for 3 computers. How to control? 3

[cimoli]

Our historical society has 3 people who use their home windows notebook. We plan to put the Access file and the Image subdirectory onto a passport flash drive.
Then the 3 people take the passport home and I would have a batch file automatically refresh their harddrive.

The problem will be that we 3 people have a different PATH that links the subdirectory to the access file. Mine is:
C:\Users\Glen\Documents\Wchs\Image\RedWingBlackbird.jpg

The others do not have Glen in their path. It is whatever their computer was setup at the store.
For instance C:\Users\Joe\Documents\Wchs\Image\RedWingBlackbird.jpg

1 - Is there a trick to make the path automatic to all 3 computers who are not in a Lan?

EG maybe a table with each person's path and a checkbox to state which is the preferred one depending on which machine is used.
And then somehow, the Access fields could take the desired path and add the file name. Like a concatenation>

2 - Also, Is there a way to doubleclick on the image to see it bigger?

An example is attached. Thanks. Cimoli.

 

[MajP]

First I always only save the image name, never a name and a path. That way when you change the path when you move the folder.
I would have a small table for user settings like:
ImageFolder
maybeOtherSettings for that user

I would keep this table in a seperate db on the user machine and bring this in as a linked table. So each user will have there own linked table that they keep on their own machine. Similar to making a split database.
Your fullpath is then done by concatenating the imagePath from table Settings with the file name. This can be done in a query used as the recordsource of your form.

However, in truth you should have this database split anyways if you have multiple users on a Lan. So you would then do it in reverse. Then everyone should have their own front end on their local machine (forms, reports, code, queries) and everyone is linking to a backend (tables) on the server. The users at home should be sent the back end and image folder only. They then would have in their front end the settings table, and they would link to the backend tables you send them. The only time users get a new front end is when forms, code, queries, and reports change.
You should never run a shared database over a network without splitting it, makes no sense.

Select ... imageFolder & ImageName as ImagePath
You then bind your image control to the concatenated field ImagePath

To get a big picture make a pop up form with a big image control on it. I would make it acdialog. Double click and open to that image.

 

[cimoli]

Thanks much MajP. Really good.