auto back up of access database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone have an easy VB script or macro suggestion on how to auto back up
an access database. I can't add other programs to my LAN so it has to be
something I can add to my database internally. Help! I lost months worth
of work because someone deleted my file and I didn't have it backed up. In
five years I have never had this problem till now.... HELP! Please!
 
Hi pj,

The problem is that the only time you can be confident that the mdb
file is in a fit state to be backed up is when it is closed - i.e. you
can't back up an Access database from within itself.

Instead, you need to arrange things so that the backup process
launches after the database is closed. If you're allowed to add
another database to your LAN, you could use the TSISOON add-in at
www.trigeminal.com in your database to launch a second database whose
only function is to run an autoexec macro that makes a copy of your
'real' database.
 
Does anyone have an easy VB script or macro suggestion on how to auto back up
an access database. I can't add other programs to my LAN so it has to be
something I can add to my database internally. Help! I lost months worth
of work because someone deleted my file and I didn't have it backed up. In
five years I have never had this problem till now.... HELP! Please!
Click to expand...

This needs to be done with considerable caution, since a copy of an open
database often cannot be trusted! If there is still some update query pending
completion, for instance, the copy may well be irretrievably corrupted.

You don't need any *software* installed to make a backup. You can, of course,
simply manually copy the .mdb file to a backup folder whenever you want; or
you can (depending on company policy) use - or get an administrator to use -
Windows Scheduler to do so.

John W. Vinson [MVP]
 
One simple way to do it is to use JetComp to do it
It will fail on an open Db, but make a compacted backup of the db if not

HtH

Pieter
 
Back
Top