What causes corruption?
Causes Corruption in Microsoft Access?
In the majority of cases, an Access database becomes corrupt due to abnormal termination of the program. Typically, this is caused by either of the following:
Many of the repairs we do are the result of an electrical storm that caused a power failure on the Server. Less often is when the Server crashes.
But sometimes it is more difficult to diagnose why the database has become corrupted. One cause can be users running a query that takes some time to complete, thinking their PC is frozen and then using Ctrl+Alt+Delete to restart their machine. Consequently the database - particularly if it resides on the rebooting users machine - is terminated without closing down in the normal way. This can cause corruption, particularly if done on a frequent basis.
Also, if you have a networking problem where a Client workstation is intermittently breaking its connection with the Server, this can cause corruption.How Can I Prevent Corruption in Microsoft Access?
There is no sure-fire way of preventing corruption. However, you can reduce the chances of data loss by doing the following:
Often, the "Repair Database" tool found under Tools, Database Utilities within Access itself can fix your database. Always try this first before contacting a data repair company as you can save yourself a good deal of money.
For more serious corruption where you cannot recover the data yourself, click here
© Access Database Repair Center 2007