Backup Database(access 2000)

[SeanITFC]

I am looking for the VBA code to backup the (current/open) database to another folder in the c:/ drive. It will sit on the on click event of a command button.

Many Thanks

SeanITFC

 

[Jacob Mathai]

use the shell command.

Create a batch file (to copy database file).
Call the batch file with a shell command.

example :

Dim Retval
Retval = Shell("D:\DATA\EXPDEMAND.BAT", 1)

 

[SeanITFC]

Many Thanks Jacob

Many Thanks for your help
SeanITFC