Command Line for Backup

[Leo]

I am trying to schedule regular compacts and backups for a database on our
server through Windows task scheduler. I got the compact to work, but am
having issues with the back-up. Here is the successful compact target:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"\\Callctrsrv\AuidtorHomeV1_1_be.mdb"/Compact

What command would I insert for backup?

 

[Chris O'C via AccessMonster.com]

(All one line

copy \\Callctrsrv\AuidtorHomeV1_1_be.mdb \\backupfolder\AuidtorHomeV1_1_be.
mdb


Chris
Microsoft MVP

 

[Linq Adams via AccessMonster.com]

I only ask this because you said "I am trying to schedule regular compacts
and backups." in that order. You are planing on doing a backup ***then*** the
compact, correct?

 

[Chris O'C via AccessMonster.com]

Good point!

Chris
Microsoft MVP

I only ask this because you said "I am trying to schedule regular compacts
and backups." in that order. You are planing on doing a backup ***then*** the
compact, correct?

 

[Leo]

You are correct. The grammar in posting was slightly confusing, but I
obviously want to back the BE data up before I campact it.

I have been tied up since I posted this, but plan to test it tonight.