Hi

Have an Access 2003 database that includes links to html photo galleries.

Each record links to a directory that contains a series of html files - the directory is named using a numeric field from the record - e.g. c:\80845

We need to archive some of these to save space - am looking for a way to automatically do the following based on a status field in the record:

1) Move the files in c:\80845 to f:\80845
2) Delete the existing c:\80845 directory
3) change the hyperlink field of the record to reflect f:\80845\index.html rather than c:

Any help appreciated

Thanks

John