Backup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone help me please, I am trying to code a command that I created (not
the usual Grey one) to back up my current database. I can't find a command
that will do that, anyone with a bright idea that could help me?
Thanking you in anticipation to whoever does come up with a solution.
 
You can use the filecopy but it wont work on a DB that is in use.
For that you can try and use, I think this line will let you copy an MDB
that is in use (current mdb)

x=shell("xcopy c:\FileName.xls c:\backup\")
 
Thanks very much Ofer, it works very well. I don't understand why the
following doesn't work.

DoCmd.CommandRun acCmdBackup

And I can't find in the help menu under Microsoft Access Constants this
command, they list all the others, as far as I am aware.
Still thanks again for your help.
 
Back
Top