hi again,
sorry i took so long to get back to you.
you can do that programaticly.
to change the file path:
Do a make table query selecting the record id and the
filepath into a temp table. in the temp table with only
the filepath and record id, do an update query and
truncate the filepath off of the image name.

UPDATE tmptbl SET tmptbl.filepath = Right([tmptbl],9);

where 9 would be the number of characters in the filepath
you want to change.
this would leave you with only the record id and the image
name in the temp table.
next do an up date query that will update your real table
with the new filepath.

UPDATE realtbl INNER JOIN realtbl ON temptbl.Id =
realtbl.Id SET realtbl.filepath = "S:\" & [temptbl].
[filepath];

where s:\ is the new file path and temptbl.filepath is the
image name.
may seem like a lot but it is rather simple.
hope this helps.
good luck