Backup

[gr]

Hi, I have read about the importance of making backups of
the back end. But is there any way automate this? I'm a
trainee I have a couple finished databases and I make a
copy paste depending of the database every week or so. My
boss says he has no time for doing this when i'm gone.

thx.
gr

 

[James Goodman]

Two things,

1. You can always use Windows backup to automate the backup process.
2. I would hope the company already has a documented backup strategy. They
should add these databases into it...

 

[Brendan Reynolds]

You can copy an MDB using the VBA FileCopy command. But I agree with James's
suggestion elsewhere in this thread. By far the best solution is to use a
dedicated backup program. These programs are developed by companies that
specialise in this area, they are tested and supported. Access developers
should not be expected to substitute for backup software developers.

 

[lj]

Just for the education of it I tried the FileCopy idea. Am I correct in my
conclusion that you cannot perform this operation on the .mdb in which you
are working (or its back-end)? It has to be done from another .mdb with your
source file closed? Just checking...

lj

 

[Douglas J. Steele]

AFAIK, the VBA FileCopy statement will not work with an open MDB, but even
if it did, it's never a good idea to copy any file that's open and in use.
In the case of an MDB, it's likely that the copied file will be internally
inconsistent if the MDB was in use when copied.

 

[Brendan Reynolds]

I have one app where I use it (I can't always follow my own advice! I
just warn the user to close any forms, other than the form that executes the
backup code (which is unbound) and to ensure that any other users on the
network do the same. This app is used by small organisations, rarely more
than two or three users, in close proximity. Something a little more
sophisticated would be required on a larger network.