How can I automate Access backup?

[blackcat9000]

Greeting bro's.

Is there a way to automatically backup an access database to a different location by a specific time?

Thanks in advance.

Blackcat9000

 

[ZmrAbdulla]

How can I do an automated back-up of my attached Back-End db using FileSystemObject?
faq181-1543
Posted: Feb 6, 2002 (Edited Jan 10, 2003)
How can I do an automated back-up of my attached Back-End db using FileCopy?
faq181-38
Posted: May 26, 2000 (Edited Jan 10, 2003)
Auto Compact your Database when FileSize = x
faq705-2852
Posted: Dec 6, 2002 (Edited Mar 28, 2003)

Also have a search on threads

________________________________________
Zameer Abdulla
Visit Me
There is only one perfect child in this world. Every mother has it.

 

[danvlas]

Copy "\\ServerName\ShareName\DBName.mdb" "\\BackupComputer\BackupFolder\DBName.mdb"

Put the above line in a batch file and run the batch through Task Scheduler. Of course, change the names first.

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[blackcat9000]

Thanks for the help guys.

Will try the above and test it out

Blackcat9000