Thursday, November 5, 2009

Access 2007 database corruption in Multi-User Environment

Microsoft Access database-sharing across a network allows multiple users to access the database records concurrently. Database sharing is primarily performed when there are large number of users who need to access or modify the records on regular basis. Although database sharing provides various benefits, it also results in two problems – Database corruption and low performance of database. In case of database being corrupted, the data stored in the database becomes inaccessible. For complete access of records in such situations, restore the records from an updated MS Access database backup. However, if no database backup is available or database backup falls short to restore the required data, then you will need to use advanced repair access file application to repair your corrupted database.

Consider a practical example, where your Accounts database gets corrupted in multi-user environment and you receive the below error message when you attempt to mount the database:

“The database engine Micro Jet has stopped the treatment because you and another user attempts to modify the same data at the same time.”

The records stored in the Accounts database become inaccessible after you encounter the above error message. Furthermore, the same error message appears each time you attempt to mount the database.

Cause:

The root cause for the occurrence of the above error message is the corruption in Accounts database due to modifications made in the same database component by two or more users.

Resolution:

To resolve the Accounts database corruption, you will need to follow the below steps:

1.Make a copy of Accounts database file, so that you can have a backup.
2.Close the new Accounts database file.
3.Delete the .ldb file.
4.Run Compact and Repair utility.

In most cases, the above steps enable you to repair your database and your database becomes accessible. But if case, the above error message still pops up after following the above steps, then you will need to use powerful Access Repair application. Such access database repair tools use intensive scanning methods to repair your corrupted database and restore them on your desired location.

No comments:

Post a Comment