Any way to have Access make a back-up of mdb file upon exit?

Is there any way in Access 2007 to have the application make a back-up file
of itself when closing the application?

well, i don't use A2007, but it may be the same as how i might do it in
prior versions. split your db, if it isn't already split. on closing the
front-end, first close all forms that are bound to a table linked from the
backend db; that should effectively "close" the backend db (assuming no
other users are actively linked to the backend). then use the FileCopy
function to copy the backend db as your backup.

hth


"vnormth" wrote in message
...
Is there any way in Access 2007 to have the application make a back-up
file
of itself when closing the application?