Wednesday, October 15, 2008

Repair Damaged Jet Database 4.0

Microsoft access is a tool to create database files as MDB format to maintain our records. MS Access can use data stored in Microsoft SQL sever, Jet database and compliant data container. There is some circumstances such as technical and physical cause due to them we can’t access our important database. These causes resemble the damaged database files.

The sign of damaged or corrupted access can range from inability to access any object to deletion of whole record. For fixing this type of problem MS access provide us Jet 4.0 service pack and compact and repair utility. Jet 4.0 fix problem like “invalid argument error when you tried to create link table using ADO” or double appearance of oracle integer files and performance problems during run of pass arguments. As Jet 4.0 database make easy our work but it also has some limitation. Sometimes Jet database get corrupted because Its memory management feature doesn’t work in context indexing operation so does not work properly during backup operation.

Common Cause of error:

  • Interruption in write operation of MS access
  • Faulty network or hardware
  • Mismatch or Incompatible version of jet database
  • Opening and saving file in another program.

This type of problem can be fixing by Jet 4.0 database engine rollup or installing Jet hotfix suite. If still your Jet database is corrupted then through Microsoft compact and repair utility you can recover your Jet database file. Procedure to recover Jet database file:

  • Install latest version of Jet database.
  • Take back up of MDB file and close this MDB
  • Now delete LDB file.
  • Run compact and repair utility from tool menu.

In this way you can repair or recover your Jet 4.0 database. If your database is probably damaged beyond repair and you are not able to repair the database. Contact some data recovery consultant or use Stellar Phoenix access recovery tool.

Stellar Phoenix access repair is easy to use and within few clicks repairs the important database files or mdb files. This access repair program recover table, queries, forms, reports, modules, relation database, OLE object, Jet 4.0 database and scan whole database object as well as check for possible error to fix them. This software is compatible with various file versions including MS Access 97 / 2000 / 2002 / XP/ 2003 / 2007.

No comments: