Switchboard Backup Module

[jcwillette]

I have a database that I have created a nice switchboard for. My problems lies in the fact that I would like the switchboard have a button to automatically backup the database instead of selecting that option through the tools dropdown menu. I assume that if I can perform that task that other tasks can be done the same way for the database clean up.

I have search this forum all day, but no idea as to where to start. I have run across the following code, but it doesn't seem to work.

Function BackupFunction()
CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Back_Up Database..."). _
accDoDefaultAction
End Function

Any help would be appreciated.

Thanks in advance.

JC

 

[RuralGuy]

Have you looked at this thread yet?

 

[gemma-the-husky]

but note that a database backup as such is a bit overrated

all you need to do is just do a daily windows copy (i dont think backup would do anything different) - you could even just copy it to a memory stick.

the other thing is - if you have a split database, as you should, then doing a backup will backup the front end (the code db), not the backend (the datadb) - and its the DATA db that should be the concern.

if your backend is on a server its probably being automatically backed up, with your normal backup procedures,