Hi, Lee.
is the following statement true:
VSS will not corrupt or damage Access Databases. However,
Access databases restored from shadow copy may be
corrupted.
I have no proof whether the VSS will or will not corrupt or damage Access
databases. From what I understand of how the VSS operates, the copy of the
file is made as soon as the data is written to disk. This _shouldn't_ cause
any interference with the original file. However, the copy may contain
incomplete transactions, which may require Jet to repair the database copy
the next time it's opened, which may not succeed in fixing the corruption.
There are so many _other_ causes of corruption that I would focus on what
else is going on with the database that might cause corruption in the
original file. Only after eliminating those other possibilities would I
return to the VSS to investigate how it might be interfering with the
original database file.
Situations that commonly cause corruption are lost network connections while
Jet is writing data to disk, faulty network interface cards, turning off the
computer's power when the Access database application is still running,
multiple users accessing the same database file from across the network
(each workstation should have its own copy of the front end linked to the
back end database file, which contains the tables, on the network),
opportunistic locking enabled on the Windows server, saving a modified
database application object (such as a Form, Report, or Module) while other
users are using the database application, compacting the database from a
workstation across the network to the server (one should always compact the
database while logged in on the computer where the file is located), and
reaching the 2 GB file size limit.
You'll find many links and much information about database corruption by
checking this Web page:
http://www.granite.ab.ca/access/corruptmdbs.htm
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
