if what you're wanting is for the DB to be copied from one location to another, then here's some ideas:
If your DB is split into frontend and backend:
On the "Quit Application" button, put a FileCopy statement in before the Quit Statement, such as :
Code:
Private Sub cmdQuit_Click()
FileCopy "C:\YourFile.mdb", "D:\YourBackupFile.mdb"
DoCmd.Quit
End Sub
If it's not split, then you'll probably have to have the DB open another Access file that copies the original one to the backup, such as:
Code:
Private Sub cmdQuit_Click()
Shell "msaccess.exe C:\MakeBackup.mdb"
DoCmd.Quit
End Sub
And in MakeBackup, have an autoexec that copies the file then closes itself, basically the same code as in the first example.
Another option is to have it compact to a new location when it closes.
I am a loud man with a very large hat. This means I am in charge
back up of the DB
