Backup of backend database

[ReidarT]

I want to make a copy of the backend database every hour.
I have made a function that copies the file. The problem is that the file is
in use and can not be copied.

On the other hand,
if I use the explorer, I can easily make a copy of the file even if it is in
use.

regards
reidarT

 

[Brendan Reynolds]

Access is smarter than Windows Explorer. Access knows that copying an MDB
while it is in use is a very bad idea. If someone happens to be writing to
the file at the time you copy it, the copy may be corrupted. And you won't
know about it until you try to use the copy, i.e. when it is probably too
late to do anything about it.

There are third-party utilities that claim to be able to safely copy open
files, but I have not tested any of them myself. FMS (www.fmsinc.com) do a
utility called Total Access Agent that can do scheduled exports of data to
text files. You'd have to develop your own routines to restore that data
from the text files if it ever becomes necessary, but I have tested Total
Access Agent, and it works well.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[joemach]

reidarT,

If you are just backing up a BE database you could use a series of Make
Table Queries (or you could write it in code). That is assuming that you
just want to back up the tables.


joemach