Backup Button on Switchboard

  • Thread starter Thread starter fox_ninja
  • Start date Start date
F

fox_ninja

I'm currently making a backup button for my database on a switchboard.
So I have made a macro which runs the function "RunCommand" I then
selected Backup from the list. However when I try to run the macro it
returns with an error called "513" and mentions that an object is not
selected.
I was wondering if it's possible to select the whole database so it is
able to be backed up from the switchboard.
Thanks
 
You can not backup a database from code that is currently running
within that database.

You'll have to change you database to use a so-called "front end/back
end" (FE/BE) structure. Then, code in the switchboard form in the FE
database, can successfully backup the tables in the BE database, if you
do it properly.

Google for FE/BE, you should find lots of information.

HTH,
TC (MVP Access)
http://tc2.atspace.com
 

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

Controlling another switchboard 2
Access Switchboard error message 1
Switchboard Minimized 4
Switchboard in Access 2007 1
switchboard problem 4
Switchboard 9
Running a Macro on a switchboard 1
Switchboard passwords 2

Back
Top