Resolving 'The Microsoft Jet database engine could not find the object MSysDb...' Access error

Published: 02nd July 2010
Views: N/A

The Microsoft Jet Database Engine is a database engine for many Microsoft applications including MS Access. It is the underlying component of Access. Microsoft Access 95, 97 create a Microsoft Jet 3.0 format database file, whereas, Access 2000, 2002 and 2003 versions create a Microsoft Jet 4.0 format database file. At times, you may encounter several errors while mounting your Access database files (.mdb or .accdb) or in worst scenarios you won't be able to even open MS Access application. Such situations surface due to corrupt Access database files and result in data inaccessibility. You can restore the data by using an updated backup. However, in the absence of a clean and valid backup, you are required to opt for an advanced Access recovery utility.



Consider a scenario, wherein, you are having an Access database in a multi-user environment, and when you try and open the application, you may receive the following error:



"The Microsoft Jet database engine could not find the object MsysDb. Make sure the object exists and that you spell its name and path name."



The above error message would restrict you from mounting the Access database.



Cause



The root cause of the error could be .mdb or .accdb file corruption. These Jet database files become corrupt due to various reasons including interrupted read/write oepration, faulty networking hardware, or opening and saving the file in another program.



Resolution



In order to fix the problem, consider using the following Access database recovery steps:



Take a backup of the affected Access database file

Run the built-in Compact and Repair utility (Jetcomp.exe), follow these steps:

1.Close the current database

2.On the Tools menu, point to Database utilities, and then click Compact and Repair database

3.In the Database to Compact From dialog box, specify the name, drive and folder for the compacted Access file

4.Click Save

5.Rebuilt the database by importing tables into a new database



If you don't get the desired results, you can always go for a third-party Access repair software. Such tools are designed to thoroughly scan corrupt .mdb or .accdb files by applying improved scanning algorithms and and extract all information.

Report this article Ask About This Article


Loading...
More to Explore