Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2015
    Posts
    1

    Answered: How to fix Corrupt Access 2010 Database repair?

    I have an Access database which was copied to an USB device and has become corrupt. I am getting the following error message:The Microsoft Jet database engine could not find the object 'Databases'. Make sure the object exists and that you spell its name and the path name correctly. (Microsoft JET Database Engine). I have attempted to repair the database, run the JETCOMP.exe, import the data from another Access database, SQL Server, Excel; and continue to get the same error. I do not need the forms, queries, reports or macro's, only the table data. I am looking for a reliable company to look at the database and extract the data or software to get the data out.

    Thanks.

  2. Best Answer
    Posted by socorrogames

    "Try this sequence in order:

    -Backup.
    Make a backup copy of the bad database, without overwriting any existing backups. Whatever has gone wrong, you don't want to make it worse, and a backup gives you multiple attempts at recovery.

    -Uncheck the Name AutoCorrect boxes.
    In Access 2007: Office Button | Access Options | Current Database.
    In previous versions: Tools | Options | General.
    For an explanation of why, see Failures caused by Name Auto-Correct.

    -Compact.
    In Access 2010: Compact and Repair Database on the Database Tools ribbon.
    In Access 2007: Office Button | Manage | Compact/Repair.
    In previous versions: Tools | Database Utilities | Compact/Repair.

    -Decompile.
    Close Access, and enter something like this at the command prompt: "c:\Program Files\Microsoft office\office\msaccess.exe" /decompile "c:\MyPath\MyDatabase.mdb"
    Use the path to where msaccess.exe is found on your computer, and include the quotes.

    -Compact again.
    Open Access (holding down the Shift key if you have any startup code), and compact again.
    Do this twice: one compact does not work in all versions (unless you close Access between step 4 and 5.)

    -Set minimal references.
    Open a code window.
    Choose References from the Tools menu.
    Uncheck any references you do not need.
    For a list of the ones you typically need in your version of Access, see Solving Problems with Library References.

    -Compile.
    Still in the code window, choose Compile from the Debug menu.
    Fix any errors, and repeat until the code compiles okay.

    -Set code options.
    Still in the code window, choose Options on the Tools menu.
    On the General tab, make sure Error Trapping is set to "Break on Unhandled Errors", and Compile On Demand is unchecked.

    If this guide didnt assist you, then I would advise you to use third party software Access Repair Toolbox http://www.access.repairtoolbox.com/"


  3. #2
    Join Date
    Mar 2015
    Posts
    27
    Try these guys. They will let you know up front, usually within an hour what can be recovered and what it will cost.

    http://www.everythingaccess.com/acce...epair_info.asp

  4. #3
    Join Date
    Apr 2015
    Posts
    1
    Couple guides, which might repair corrupted .mdb file..

    In case such problem as: cannot open a form or report

    While developing forms, reports, and the code in their modules, they
    are likely to corrupt. To work around this, import the other objects
    into a new database:

    -Create a new database.
    -Turn off the Name AutoCorrect check boxes:
    In Access 2010: File | Options | Current Database.
    In Access 2007: Office Button | Access Options | Current Database.
    In Access 2000 - 2003: Tools | Options | General.
    For details of problems this mis-feature causes, see Failures caused
    by Name Auto-Correct.
    -Import the tables, or link them if the database is split.
    In Access 2007 or 2010, choose External Data | Import | Access.
    In Access 95 - 2003, choose Get External on the File menu.
    -Import the other objects (queries, forms, reports, macros, modules.)
    -Set minimal References under Tools | References (from the code
    window).
    -Compile (Debug menu, from the code window).

    If one form or report is corrupt, the process will cease at step 5.

    You will see the name of the object that has not been imported, and
    you can then try the import again, skipping the bad form(s)/report(s).

    With a bit of luck, you may be able to import these from a previous
    backup.

    If nothing helps, they you may apply to third party software, that
    restores MS Access databases in cases severe corruption: Access Repair Toolbox http://www.access.repairtoolbox.com/

  5. #4
    Join Date
    Apr 2015
    Posts
    1
    Provided Answers: 1
    Try this sequence in order:

    -Backup.
    Make a backup copy of the bad database, without overwriting any existing backups. Whatever has gone wrong, you don't want to make it worse, and a backup gives you multiple attempts at recovery.

    -Uncheck the Name AutoCorrect boxes.
    In Access 2007: Office Button | Access Options | Current Database.
    In previous versions: Tools | Options | General.
    For an explanation of why, see Failures caused by Name Auto-Correct.

    -Compact.
    In Access 2010: Compact and Repair Database on the Database Tools ribbon.
    In Access 2007: Office Button | Manage | Compact/Repair.
    In previous versions: Tools | Database Utilities | Compact/Repair.

    -Decompile.
    Close Access, and enter something like this at the command prompt: "c:\Program Files\Microsoft office\office\msaccess.exe" /decompile "c:\MyPath\MyDatabase.mdb"
    Use the path to where msaccess.exe is found on your computer, and include the quotes.

    -Compact again.
    Open Access (holding down the Shift key if you have any startup code), and compact again.
    Do this twice: one compact does not work in all versions (unless you close Access between step 4 and 5.)

    -Set minimal references.
    Open a code window.
    Choose References from the Tools menu.
    Uncheck any references you do not need.
    For a list of the ones you typically need in your version of Access, see Solving Problems with Library References.

    -Compile.
    Still in the code window, choose Compile from the Debug menu.
    Fix any errors, and repeat until the code compiles okay.

    -Set code options.
    Still in the code window, choose Options on the Tools menu.
    On the General tab, make sure Error Trapping is set to "Break on Unhandled Errors", and Compile On Demand is unchecked.

    If this guide didnt assist you, then I would advise you to use third party software Access Repair Toolbox http://www.access.repairtoolbox.com/

  6. #5
    Join Date
    Apr 2015
    Posts
    1
    You may also read and learn helpful resource/soltution https://social.technet.microsoft.com...eitproprevious where is discussed the same issue

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •