Back up database

  • Thread starter Thread starter Box666
  • Start date Start date
B

Box666

I wish to take a regular monthly back up of a database. I realise I can
do a "copyobject" macro, but there are a large number of tables,
queries etc., besides each time a new query or report is added
"somebody needs to remember to add each to the backup macro.

Ideally I want to run the backup from a button on a form within the
database. Is a backup possible in this way or do I need to rethink the
problem.
 
Others may have differing opinions, but I back up my databases just like
any other work file I need to protect. Not from within Access, but via a
Windows backup to CD type program.
For example, I keep all my Access Apps under a directory called
C:\Program Files\Access97\..., so I just include C:\Program
Files\Access97\"*" in my normal backup.
You should be running a regular Backup program on your PC anyway... so
why not just include the .mdb files?
 
Back
Top