Re: [ADSM-L] open Access files

2007-08-17 19:17:04
Subject: Re: [ADSM-L] open Access files
From: Richard Sims <rbs AT BU DOT EDU>
Date: Fri, 17 Aug 2007 19:15:05 -0400
On Aug 17, 2007, at 5:54 PM, William Boyer wrote:

Yeah, but unless the Access application opens the database with
exclusive use, you can get a backup of an open Access database. And
even Microsoft says that's a no-no. I use to have a link to a KB
article at Microsoft that said even doing a COPY of an open MDB
file would leave the copy corrupt and unusable. Retrying 3-times
(SHRSTATIC) is OK, but if the file doesn't change and is just open
during the backup, you got a backup that might not be any good.

As List participants have tried to point out in the past, backing up
the physical files constituting a database while the database
facility is running is shooting in the dark.  Even if you can get a
good backup of the files, that by no means assures that you have
consistent data, given that so many pieces of the database may be in
memory.  Database systems provide access APIs and IBM provides TDPs
based upon them because that's the right way to perform backups on
these dynamic systems.

   Richard Sims

<Prev in Thread] Current Thread [Next in Thread>