Announcement

Collapse
No announcement yet.

Salvaging Tables from Corrupted .MDB file - Special Utilities Available Perhaps?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Salvaging Tables from Corrupted .MDB file - Special Utilities Available Perhaps?

    "The Microsoft Jet database engine cannot find the object 'Databases'. Make sure the object exists that that its name is spelled correctly." I am getting this error message when attempting to open our production .MDB. Before we get into discussions about workstation configuration, let me state clearly that the error message does not occur when attempting to open a copy of the production .MDB which was restored from back-up yesterday afternoon. Nor does it occur when Access opens any of other other production .mdb's. This problem appears to be solely and exclusively related to this particular .mdb file.

    Attempting to Compact the .MDB using JETCOMP.EXE results in an "Error Compacting Database" error. Attempting to open the .MDB using Access results in the "can't find the object 'Databases' error message. In short, I have no tools at my disposal which will open the .MDB. I have tried importing into a new .MDB, but Access generates the same error message the instant it attempts to open the corrupted .MDB.

    Is there any special utilities for dealing with .MDBs which have been corrupted to this degree? I would very much like to harvest at least one of the tables....

  • #2
    Based on your description, your MDB database is so corrupt that the build-in "Compact and Repair" command in Access cannot help to fix it any more.

    In such a case, you can try third-party Access data recovery tools, such as DataNumen Access Repair at:

    https://www.datanumen.com/access-repair/

    I have used the tool in the past and it helps recovering many valuable data for me. The tool has a free demo so that you can try before you buy.

    If you prefer to use a service instead of a product, then you can use Everything access data recovery service at:

    http://www.everythingaccess.com/

    Good luck!

    Comment


    • #3
      Short guide can be helpful for you, if not see helpful topics are collected over Internet, if again they can't help you, then your corruption is complicated and needs to solve via more powerful solution http://www.mdb.openfiletool.com/ MDB Open File Tool

      http://www.itninja.com/question/copy...-pc-to-network
      https://ask.sqlservercentral.com/que...rior-solu.html

      Launch the Microsoft Access application, but do not try to open the corrupted MDB file.
      Go to "Tools" in the top menu bar, expand the "Database Utilities" submenu and select the "Compact and Repair Database" option if you are using Access 2002 or 2003. If you are using Access 2007 or 2010, you can find the "Compact and Repair Database" option by clicking the Microsoft Office button and going to the "Manage" menu.
      Highlight the MDB file that you want to restore and click the "Compact" button.
      Enter a name for a new database file, which will contain the restored data from the damaged MDB file.
      Navigate to the location on your hard drive where you want to save the restored version of the file.
      Click the "Save" button. Access will now compact and repair the MDB file and save a restored version in the location you selected.

      Comment

      Working...
      X