how can I backup a database with a macro

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

Guest

I want to have a switcboard option for backing up a database. I'm trying a
macro with the the runCommand 'backup' action. I get the following error when
I run the macro.

The command or action 'Backup' isn't available now.

Can anyone help wit this?
 
Create another database that backups your main database, then schedule this
new database using the windows scheduled tasks option to run the backup
automatically
 
I see how having a scheduled backup would work.
However, I want to provide the user of the database with the option to back
up the database when he wants. I would like to use the new command (as of
Access 2002/3): Back Up Database ... (this is found on the File menu and the
Tools --> Database Utilities menu). This command is available only when you
have a database open and does not allow you to specify which database you
would like to back up (it assumes the currently open database), then you are
allowed to specify the location and file name. This command works fine from
the menu, but when you try to execute it from a macro or VB code, you get the
message: The command or action 'Backup' isn't available now (see original
post). Thanks, Jim
 
Back
Top