Fixing Corrupt Access 2003 DB: Error "Database Engine Could Not Find MSysDb

  • Thread starter Thread starter sagebishop
  • Start date Start date
  • Tags Tags
    Db
Click For Summary

Discussion Overview

The discussion revolves around issues related to a corrupt Access 2003 database, specifically focusing on the error message "database engine could not find object MSysDb." Participants explore various methods for attempting to repair the database and address the limitations of certain repair tools.

Discussion Character

  • Technical explanation
  • Debate/contested

Main Points Raised

  • One participant reports being unable to open the Access 2003 database due to the MSysDb error and mentions that attempts to use JetComp, import tables into a new database, and open the database in Access 2007 have all failed.
  • Another participant provides a link to a known problem regarding the MSysDb error, suggesting that it is a recognized issue within the community.
  • A different participant describes the steps to access the Detect and Repair tool in various versions of MS Access, detailing how to navigate the menus in Access 2003 and 2007 to use this tool.
  • One participant notes that the repair method primarily focuses on recovering tables, indexes, and queries, and advises against attempting to repair forms, reports, macros, and modules. They also outline conditions necessary for running the Compact and Repair tool, such as ensuring the database is closed and sufficient storage space is available.

Areas of Agreement / Disagreement

Participants present various methods and tools for addressing the database corruption issue, but there is no consensus on the effectiveness of these approaches or a definitive solution to the problem.

Contextual Notes

Some limitations are noted regarding the repair methods discussed, including the focus on specific database components and the requirement for certain conditions to be met before attempting repairs.

sagebishop
Messages
1
Reaction score
0
Access 2003 database. Unable to open - error message "database engine could

not find object MSysDb".Can not JetComp it; can not import tables into a new db; can not open in

Access 2007; can not compact & repair.
 
Technology news on Phys.org
The Microsoft provided Detect and Repair tool can be accessed from different locations in MS Access XP, MS Access 2003, and MS Access 2007. In MS Access XP and MS Access 2003 the tool can be accessed by selecting Help > Detect and Repair option. While in MS Office 2007, you need to execute the following steps to access and use the tool:

1. Start MS Access 2007.

2. Click The Microsoft provided Detect and Repair tool can be accessed from different locations in MS Access XP, MS Access 2003, and MS Access 2007. In MS Access XP and MS Access 2003 the tool can be accessed by selecting Help > Detect and Repair option. While in MS Office 2007, you need to execute the following steps to access and use the tool:

  1. Start MS Access 2007.
2. Click the MS Access button and click the PowerPoint options button.

3. Select the Resource Tab.

4. Click the Diagnose button.

After you have launched the tool using the MS Access application follow the onscreen instructions to use the tool.
 
  • Like
Likes   Reactions: sagebishop
The repair method attempts to recover only the tables, indexes and queries in the database. Do not attempt to repair damaged forms, reports, macros and modules. Before executing the Compact and Repair tool, please ensure the following condition:

1. Do not open Access database must closed

2. Sufficient storage space available - minimum double in size of your Access database on that Disk.

3. Close the .mdb file related to .ldb file before you delete the .ldb file.

4. Then Run the Compact and Repair tool
 

Similar threads

  • · Replies 8 ·
Replies
8
Views
3K
  • · Replies 1 ·
Replies
1
Views
4K
Replies
5
Views
14K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 7 ·
Replies
7
Views
4K
  • · Replies 1 ·
Replies
1
Views
2K
Replies
2
Views
3K
  • · Replies 5 ·
Replies
5
Views
11K
Replies
4
Views
3K