if you are going to put the final product on a shared network drive it should be fairly simple to figure out the path. I would, however, split the database into a front end/back end so each person can have their own copy of it.
let's say a person had item 12345 selected. you could get a list of files this way:
Code:
dim sPath
dim fs, fsFile, fsFolder
dim iProd
iprod = x 'this is where you'd put in your product number i.e. pulling it from a text control or list box on a form
spath = replace(currentproject.path & "\", "\\", "\")
set fs = createobject("scripting.filesystemobject")
set fsfolder = fs.getfolder(spath)
set fsfile = fsfolder.files
for each file in fsfile
if left(file.name,5) = iprod then
debug.print file.name
endif
next file
this just a simple looping mechanism to find files associated with your product number. Once you get that part working if you want to use it to update a table in your database you can to get image file names etc. I would avoid storing the path though because if your database and images are in the same places relative to each other you can get the 'starting' location with currentproject.path for each individual user.