Restart Exclusive and then Backup Database?

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

Guest

So, DoCmd.RunCommand acCmdBackup doesn't work (not even sure if acCmdBackup
is the right one to use) - it gives an error that command isn't available
now. But, I want the user, to be able to click a button and be able to save
a copy of the .mde with all the data that they've currently entered.
There're going to be multiple copies of the database spread around, each with
their own dataset, so I can't hardcode the path.
 
I can back up the database manually when I can't use this. Hmmm. So maybe I
do have the constant wrong? I'm going to Tools>Database Utilities>Back Up
Database . . .
 
I answered my own question:

'Application.RunCommand acCmdBackup
' The above code, though it should work, does not. This is a workaround.
CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database Utilities"). _
Controls("Back Up Database..."). _
accDoDefaultAction
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Constant for "Back Up Database?" 1
backup access 2003 9
VBA to Compact or Backup an Access database? 2
Backup difficulty "Opened Exclusively" message 3
"Copy" isn't available now Error 1
Open Exclusive unavailable in Access 2007 database. 4
Database is opened exclusively error 4
Database Exclusive 6

Back
Top