Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Corrupt Access DB

  1. Jul 23, 2015 #1
    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.
     
  2. jcsd
  3. Jul 23, 2015 #2

    jedishrfu

    Staff: Mentor

  4. Jul 24, 2015 #3
    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.
     
  5. Aug 9, 2016 #4
    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
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: Corrupt Access DB
  1. Java (access question) (Replies: 3)

Loading...