Monday, September 1, 2008

File corruption in Jet file-sharing database system

Microsoft Jet database is a file-sharing database system. A file-sharing database system means that the processing of the file occurs at the client. In order to allow multiple users to share the same file over the network, Jet Database Engine uses a Lock file (.ldb) to synchronize the read write operations of the database. When a file-sharing database, such as Microsoft Jet, is used in a multi-user environment, multiple client processes use file read, file write, and file locking operations on the same shared file across a network.

If a process cannot be completed, the file may be left in an incomplete state or in a corrupted state. When you use Microsoft Jet in high-stress applications such as Microsoft Internet Information Server (IIS), you may experience any one of the following problems:

  • Database corruption
  • Stability issues, such as IIS crashing or locking up
  • Sudden failure or persistent failure of the driver

Opportunistic locking may increase the risk of Jet database corruption when a file is shared by two or more clients on a network file server. Most of the times, the network problem leave the Access database in a “Suspect” state and cause corruption. In all of these situations, you need to repair your Access database in order to use it.

If you disable opportunistic locking, this may adversely affect the performance of other applications. To get rid from this solution you can install latest service pack provided by Microsoft or latest Jet hotfix service pack. Problems also occur when you restart the server after you apply new software or you apply a service pack or a hotfix, and you forget that the Microsoft Jet database is currently shared on the server. In this situation you need a tool called access recovery tool which have capability to repair your Access database.

These softwares work on the header of the corrupted file and repairs and restores it without changing the original contents of the database files. Stellar Phoenix Access Repair is best data recovery software to restore your corrupted database by fixing bugs and errors. Using this utility you easily repair forms, queries, table, modules and macros. Stellar Phoenix scans for corrupted files to repair and restore it to a default location or a user specified location on the hard drive. It is compatible with all file versions of Microsoft Access such as Access 97, 2000, 2002, 2003 and 2007.