Manipulating external images

[John]

Hi

We have a staff file in which each record has a text field which has the
name & path of the staff's picture (stored externally). Over years we have
archived several staff but pictures being external entities are still in the
pictures folder. Is there a way to programmatically do the following;

1. Find the pictures that do not have an associated staff record in the
staff file (i.e. pictures that or not in any of the staff's picture field)?

2. Move these pictures to an archive folder?

Thanks

Regards

 

[Arvin Meyer [MVP]]

The way I'd do it is to import the current filenames into a table using
something like my PictureMgr database app:

http://www.datastrat.com/Download/Picture2K.zip

Then I'd use a Find Unmatched query (there's a wizard to pop out the names
of the files that no longer existed, and append them to your archive table.
Then delete those from your origin al table.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access