February 11th, 2002, 12:59 PM
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?
February 11th, 2002, 08:53 PM
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.
February 11th, 2002, 09:16 PM
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?
-- Cigars, whiskey and wild, wild women. --
February 11th, 2002, 09:19 PM
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.
February 11th, 2002, 09:31 PM
I've got it in a .bat file. Thanks for your help.