none
MS Access. Errors detected. RRS feed

  • Question

  • Hi everyone,

    Here's my problem:
    Microsoft Access 2013 crashed while I was editing .mdb format file. My document became unable to be opened because of the following message: Errors detected in the file.  Please help me to repair .mdb document. 

    Any help would be appreciated.
    Tuesday, January 17, 2017 11:18 AM

Answers

All replies

  • What is the exact error message and number?

    Do you have a backup copy you could simply fall back on?

     

    If you have not done so yet, make a copy of your db before trying to fix it.  Always work off of a copy and keep the original separate.

    Have you tried performing a starting access using the /repair  command line switch?

    Have you tried starting a new blank db and seeing if you can import the objects from your corrupt database?


    Daniel Pineault, 2010-2016 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net


    Tuesday, January 17, 2017 2:30 PM
  • SSBates -

    I've occasionally had troubles with the mdb format as well. If given the chance, I copy the file and convert it to accdb as soon as possible... but that requires the file to open successfully.

    The first thing is to find a backup & copy only the mdb into a new folder & try to open that.

    The second thing - because (ahem) "I don't want to lose my changes since the 'backup'" - I try is copy the errant mdb into a new folder, leaving the matching ldb file behind. In fact, I make sure that file is not to be found in the path.

    The third thing is to open the file with macros disabled; or else I hold the shift key down as the file opens so that any auto open code does not execute.

    If things don't work at that point, you could create a shortcut to open the file in MSAccess with a '/compact' option (the target would be similar to "C:\Program Files\Microsoft Office\Office15\MSACCESS.exe G:\MyStuff\ThisTroublesomeAccessfile.mdb /compact" (Search for MSAccess commandline switches as there are others that may be helpful - http://www.utteraccess.com/wiki/index.php/Command-Line_Switches, or the oldie... https://support.office.com/en-us/article/Command-line-switches-for-Access-558CFE1D-3C98-4292-BEE8-1F5DF9702BF1)


    -MainSleuth You've Got It, Use It! Engineering, Science, Statistics Solutions http://ToolSleuth.com


    • Edited by MainSleuth Tuesday, January 17, 2017 2:42 PM
    Tuesday, January 17, 2017 2:38 PM
  • The exact error - "Errors detected in the file" . I haven't a backup copy:(

    I have tried Repair command. No luck. Also I have have tried starting a new blank.


    Tuesday, January 17, 2017 6:12 PM
  • Many thanks for the helpful answer. 
    Tuesday, January 17, 2017 6:13 PM
  • All is not absolutely lost -

    From a new database, you can also try to import the various tables, queries, forms and reports - Ribbon, "External Data/Import & Link", select the Access icon, browse to the filename and select the Import radio button. I'd import each category on it's own. In other words, tables first, then Queries, then Forms, then Reports & finally macros & modules. I'd also expect one or more of these to 'blow up'. hopefully it's not your tables.


    -MainSleuth You've Got It, Use It! Engineering, Science, Statistics Solutions http://ToolSleuth.com

    Tuesday, January 17, 2017 7:39 PM
  • Two things:

    1. Check to see if Windows Restore might be backing up your files unbeknownst to you. Are you sure you do not have your Shadow Copies enabled on your hard drive? This, at least, would give you a backup if the .mdb was around long enough for the Shadow Copy to back it up (I think the auto-configuration is twice a day for Shadow Copy backups). Shadow Copy is also part of System Restore.

    Try this:
     Right-click the folder containing your .mdb
     See if is an option to "Restore previous versions". If so, you may be able to open that and retrieve a prior version of your file. If not, you still might be able to do a System Restore targeted to just the file you need (just not sure how that part works).

    2. You might be able to decompile the .mdb if using the /repair option does not work. You can run the command below from the command prompt. Replace the bracketed portions with the actual path to MSAccess.exe and to your .mdb file, and include the double-quotes.

    "C:\[PathToFolderContainingAccessExe]\msaccess.exe" /decompile "C:\[PathToYourMDBFile]\[YourFileName].mdb"


    Tuesday, January 17, 2017 8:03 PM
    • Marked as answer by SSBates Thursday, January 26, 2017 3:31 PM
    Tuesday, January 24, 2017 12:21 PM
  • I want to say thank you for taking the time to share how to go about fixing this.
    Thursday, January 26, 2017 3:31 PM