How can I prevent database corruptiuon?

M

mdwilcher

Using Access 2003. Have had corruption problems in the past causing me to
keep my users out of the database for hours. I want to find a way to prevent
corruption so that this problem doesn't occur again
 
J

John Vinson

Using Access 2003. Have had corruption problems in the past causing me to
keep my users out of the database for hours. I want to find a way to prevent
corruption so that this problem doesn't occur again
Click to expand...

It's probably impossible to *absolutely* prevent *all* corruption;
computers are fallible after all!

But check out the suggestions at

http://www.granite.ab.ca/access/corruptmdbs.htm

The two most common causes of corruption are users (lusers!?) who
ctrl-alt-delete and stop Access while it's updating something, and bad
Network Interface Cards. Good application design can make the
circumstances which cause corruption less frequent (slow performance
which frustrates users into giving the three-finger-salute for
example).

If you have mission-critical data and need live backups, routine
commits and rollbacks, etc. then you should consider using SQL/Server
or another client/server system. They can get corrupted too, but have
a lot more tools to prevent and recover from corruption.

John W. Vinson[MVP]
 
A

Albert D.Kallal

Usually, corruption occurs due to a incorrect setup, or users hitting re-set
on their computers.

If you are going to use ms-access in a multi-user environment, then you need
to split the database
You can read why you need to split your database here, but suffice to say in
a multi-user
environment, you have to split. The following article not only tells you
that you should split,
but also tells you why:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

As for a faq, and how to prevent corruption, check out the following gem:

http://www.granite.ab.ca/access/corruptmdbs.htm

Also, you need to ensure you have a good quality network connection.

It is not clear if you are in a multi-user environment at all here, but a
flaky network can often be the problem...
 
R

Ron Hinds

In addition to the other suggestions, make sure you aren't using a wireless
network - they can cause Access corruptions, too.
 
Top