#1
  1. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,643
    Rep Power
    4492

    Regularly copy file between two networked systems


    How would I set up a recurring file copy between two computers on a network?

    I have an access database that I want to copy to another machine every night. Anybody know how I would do it?

    ---John Holmes...
  2. #2
  3. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,638
    Rep Power
    4247
    Use the AT command line program to set up jobs to run at specified intervals. (type HELP AT at the command prompt to see how to use this command). Then, all you have to do is make sure that the Schedule service is running.

    If you don't feel like using the AT command line tool, there's a GUI version called WinAT or something like that which comes with the microsoft plus pack. Also with Windows 2000, there's a tool called Task Scheduler which does pretty much the same thing.
  4. #3
  5. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,643
    Rep Power
    4492
    I'll do that, thanks.

    I figured out the command, it was pretty simple. didn't know there was a command line copy...

    COPY /V /Y /B "C:\FILE.MDB" "F:\"
    COPY /V /Y /B "C:\FILE.MDB" "\\COMPUTER\DIR\"

    If I set this up as an AT program...does someone have to be logged onto the computer for it to work? Once people leave for the day, they log off, but the computer is generally left on. Would the scheduled copy still go through?

    ---John Holmes...
    -- Cigars, whiskey and wild, wild women. --
  6. #4
  7. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,638
    Rep Power
    4247
    The scheduler runs even if the user has logged off. I would put all the commands into a batch (.BAT) file and then pass the BAT file to the AT command prompt instead of the individual commands. Then again, this is just my way of doing things.
  8. #5
  9. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,643
    Rep Power
    4492
    I've got it in a .bat file. Thanks for your help.

    ---John Holmes...

IMN logo majestic logo threadwatch logo seochat tools logo