What is Database Corruption

Database Corruption can happen when a database loses connection for multiple reasons

There are multiple things that can lead to corruption on a Database.  One of the MAIN things that creates corruption is the use of a wireless network to access your database on another machine.  This is why we Highly Recommend that ALL machines in your network that use our software are "Hard Wired".

Whenever your hardware fails in storing or transferring the data of your Access databases, the databases will likely get corrupted. There are mainly three types:

Data Storage Device Failure. For example, if your hard disk has some bad sectors and your Access MDB file is stored on these sectors. Then you may read only part of the MDB file. Or the data you read are incorrect and full of errors.

Faulty Networking Device. For example, the Access database resides on the server, and you try to access it from a client computer, via network links. If the network interface cards, cables, routers, hubs and any other devices constituting the network links have problems, then the remote access of the MDB database may make it corrupted.

Power Failure. If a power failure happens when you are accessing the MDB databases, that may leave your MDB files damaged.

There are many techniques to prevent or minimize the Access database corruption due to hardware problems, for example, UPS can minimize the power failure problems, and using reliable hardware devices can also reduce the chances of data corruption.

The following links can be used to learn how to compact and repair and/or backup your database.

Backing up database

Compacting and repairing database