Shared db and photo paths...

Hi, all ~

I have a personnel database with photos. To avoid the dreaded
OLE bloat, the photos are just picture controls with the data source
set to the path where the picture is stored. Works great on my
system, where the db resides.

However, when I open the db from another machine, the photos don't
display, because the path is for my system. I tried using absolute
paths (like \\MyDomain\MySystem\c:\myfolder\database\photos),
but that doesn't work either.

I suppose the easiest way out would be to put the db and associated
files on a network drive and make sure all users map the drive to the
same letter, so the referred path is "Z:\database\photos", but I'd rather not
do that.

Anyone have any alternatives??