Top 10 ways to prevent Access database corruption

1
Top 10 Ways to Avoid Access Database Corruption
2
Table of Contents
Check the server's configuration
Split your database
Store temporary tables in a backend
Don't store picture files
Don't use memo fields
Be careful with WAN connections
Create temporary tables to speed up queries
Be careful with wireless networks (WiFi)
Troubleshoot network hardware
Don't put Mac and Windows users on the same
network
3
About
The database corruption is an occurrence of any
type of error on the particular database. MS
Access database is one of the important
applications of Microsoft and is basically used
to store data in .mdb and .accdb file format.
However corruption can anytime happen and
therefore it becomes necessary to prevent that
corruption so that the data stored in it can be
safe. Proactive approach should be to avoid
corruption in first place. Here you will get to
know about some preventive ways to protect your
Access database.
4
1- Split your database
If your database is accessed by more than one
person then it will be better that split it into
two pieces. First, a backend which stores the
entire data in tables and second, the front end
which consists of everything else like forms and
reports. After that, name both the ends properly
and always remember that your data is like gold.
5
2- Store temporary tables in a backend
If your database populates, creates and after
that removes the temporary tables then you should
keep all those tables in separate backend
database to avoid bloat. You should name the
extra backend accordingly and this backend should
be shared or local.
6
3- Don't use memo fields
Try not to use memo fields when possible.
Sometimes they cause corruption and it needs to
be repaired but still some data gets lost from
memo fields. So if you want memo fields then keep
them in separate tables and dont forget to
create one to one relationship to parent table.
If you want better then move the memo tables to
separate backend database file and after that
name the file accordingly to specify the purpose.
7
4- Create temporary tables to speed up queries
When you run nested or complex queries then
access may write temporary data which you never
see. Generally such thing happens when query
works in small amount of data performs slowly
that puts stress on JET engine. But when access
chokes in between the process then backend will
get corrupt.
8
5- Don't put Mac and Windows users on the same
network
When users of both Windows and Mac share the same
network then they can face the same issue and
here separate network should be establish for
database users. Generally Mac is noisier and it
also generates wide amount of network traffic
while moving large graphics. Therefore only use
high quality network components.
9
6- Check the server's configuration
The server configuration where you have stored
the shared backend database may be sometimes the
culprit. Therefore it becomes important to
monitor and fix such type of error. However there
are lots of possibilities from server parameters
to malfunctioning disc controller to
misconfigured RAID array.
10
7- Don't store picture files
It is generally instructed not to store picture
files in database. If you can then treat them in
the same way as you have done with memo field.
However access has no problem in attaching tables
from several backend databases.
11
8- Be careful with WAN connections
If the WAN connection covers any type of
connection from local system to a server through
internet then it can cause a big trouble. In
between reading the database can be slow but it
can be acceptable. Although, the database can
cause corruption and error prone while writing
the database. But when any type of interruption
happens while access times out or data transfer
due to connection lost then the backend database
gets corrupted.
12
9- Be careful with wireless networks (WiFi)
If you are using Wi-Fi connection then its fine
but always is careful because several users or
neighborhood networks can really shut down the
connection. At that time if you are writing then
the database can get corrupt and this type of
interference is not a big issue when users are
reading from the database.
13
10- Troubleshoot network hardware
When corruption happens after every time interval
then its a problem of network hardware issue and
you have to deal with. So try to narrow down the
workstation and after that change the error prone
station with another. If issue follows
workstation then it can be easy to get rid of
workstation as you know its the source.
14
Recommended Solution
However after applying all the ways to prevent
access database corruption, still if you face
issue then you should fix the corruption problem
with the help of powerful MS Access Repair Tool
which completely repairs the access database
corruption. This is one of the best repair tools
which easily fix any type of corruption in Access
database.
15
For More Information
http//msaccess.filerepairtool.net
https//www.pinterest.com/alexwaston14/file-repair
-tool/
https//plus.google.com/u/1/b/10144174353899932597
0
https//twitter.com/access_repair