Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Carrollton, Georgia, USA
    Posts
    123
    Thanks
    3
    Thanked 1 Time in 1 Post

    Directory Copy (Access 97 - SR2)

    Thanks to HansV, last year I used Access to move/rename files & directories. Program working very well. -Thanks again Hans!

    I'm using the program now to automatically up date my web site. I have template directories set up, and I want to have Access copy those directories and rename them. This allows all the control files / html files to be duplicated at one time, and then the necessary files replaced.

    Any ideas?

    Thanks!
    KST

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Directory Copy (Access 97 - SR2)

    If you set a reference (Tools | References...) to one of the scripting libraries, for example Microsoft Scripting Runtime, you can use the FileSystemObject. One of its methods is CopyFolder. See CopyFolder Method.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Carrollton, Georgia, USA
    Posts
    123
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Directory Copy (Access 97 - SR2)

    Hans,

    I can only get this method to copy about 41 to 42 files, then I get an error... Run time error '53' File not found

    The file is there.....

    Any ideas?

    Thanks!
    KST

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Directory Copy (Access 97 - SR2)

    It took you 9 months to copy 41 files? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

    Seriously, could you post the code you're using?

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Directory Copy (Access 97 - SR2)

    <hr>It took you 9 months to copy 41 files? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29><hr>
    Maybe Scott uses dial-up access? <img src=/S/doze.gif border=0 alt=doze width=15 height=15>
    Wendell

  6. #6
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Directory Copy (Access 97 - SR2)

    It's like in the movie Wargames..he dials the number on a normal phone, waits to hear the modem connection, and then sets the receiver on that nifty computer add-on...
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

Posting Permissions

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