Automate backup

  • Thread starter Thread starter Charles L. Phillips
  • Start date Start date
C

Charles L. Phillips

Hello,
I have a MS-Access 97/2003 database, on a Windows XP system acting as a
server for the database.
I need to backup this database everyday, twice a day, at 12:30 p.m. and at
9:00 p.m. to another hard drive.
My question, "can this be done automatically & how...
Can someone point me to some examples???


Thank you,
 
Yes but not having a true server, you cannot kick anyone out of the database
very easily to make the copy. You can use FileCopy to do the work after you
get them kicked out.

FileCopy "F:\PathTo\Data.mdb", "G:\PathTo\Data.mdb"

You might want to have a look at the kickemoff utility and code at:

http://www.datastrat.com/Code/KickEmOff.txt
and
http://www.datastrat.com/Download/KickEm.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Hello,
Is there a way to do this with XCOPY /v???
How do you run a batch file in "Schedule Task"????


Thank you,
--
Charles L. Phillips


Arvin Meyer said:
Yes but not having a true server, you cannot kick anyone out of the database
very easily to make the copy. You can use FileCopy to do the work after you
get them kicked out.

FileCopy "F:\PathTo\Data.mdb", "G:\PathTo\Data.mdb"

You might want to have a look at the kickemoff utility and code at:

http://www.datastrat.com/Code/KickEmOff.txt
and
http://www.datastrat.com/Download/KickEm.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
Click to expand...
 
You are possibly missing his point.

There is no value taking a copy of the database file, while anyone
still has it open. It doesn't matter how you take that copy. The copy
possibly won't be usable, if it was taken when someone had the file
open. So you will /think/ that you have a backup, but the backup file
might not actually work.

You need to design some plan for dealing with this, before you worry
about the mechanical details of taking the copy (normal copy, xcopy,
scheduled, not scheduled, whatever).

As for running a batch file through the task scheduler, have you
checked through Windows Help? That's not really an Access question. Try
asking in a windows xp newsgroup, if it's not in Windows Help.

HTH,
TC [MVP Access]
 
Back
Top