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

  • Thread starter Thread starter vnormth
  • Start date Start date
V

vnormth

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
 
You must log in or register to reply here.

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

Converting mdb to txt file 3
Want to set version of an application developed in MS Access... 3
looking for a way to unlock a back end mdb file 16
Problem connecting to access database. 1
mdb format and Access 2007 3
Design View not available for mdb file. 5
Can you save an MDB file using VBA? 2
import a query from a text file 3

Back
Top