Backup

[border20]

Is there a way to make automatic backups on a daily basis... from code... ?

thx

 

[pono1]

If you want to back up to another PC on a network, an easy solution is to create a batch file with a copy command and then use Windows Task Scheduler to run the file late at night...

Another solution I've seen people use is to call a batch file at exit (using the shell command), zipping and copying the file to another drive. You could also -- rather than run a batch file -- export tables to another Access file at exit. And, I suppose, you could use the Timer Event to export your app's tables to another Access file.

A tape drive with backup software that can run on a schedule is yet another way to go -- no code needed.

Regards,
Tim

 

[border20]

ok thx

but how do i create a batch file with that command ??

 

[R. Hicks]

If the database is split ... normally only the Backend file (data file) is backed up.

If this is your setup ... then take a look at the information at the location below.

BackUp BackEnd Database (Split DB only)

HTH
RDH

 

[Oldsoftboss]

Something from Candice Tripp
HTH
Dave