Auto Backup

N

Neil Greenough

If I set up a split database (MS Access 97) on a network, is there a way I
can set up something so that the database automatically creates / updates a
back up at a certain time each day?

If not, is there some VBA code that I can put behind a button that, when
clicked, will update a back-up backend DB?

Kind regards
 
O

Ofer

I think the right way is to define some task in windows that create a
directory and copy the DB to that directory.
if you cant find a solution, then mybe you can use that code:

' Make a directory to save the file to, better has date and time
dim MyDateStr as string
MyDateStr = format(now,"yyyymmddhhmm")
MkDir "c:\BackUp\" & MyDateStr
' copy the mdb to that directory
shell ("xcopy c:\MyDB.mdb c:\backup\" & MyDateStr )
 
Top