Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    1

    Unanswered: Move files / update hyperlinks

    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

  2. #2
    Join Date
    Jul 2004
    Location
    South Dakota
    Posts
    267
    John--

    Try using the Name statement - you can actually move files with it. Also the MkDir statement will make a new directory on the drive specified. And lastly, you can use the Kill statement to delete the old files/folder. Hope that's a start.

    C

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •