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

V

vnormth

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

tina

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
 
Top