none
Cannot extract data RRS feed

  • Question

  • I created some tables in my database some days ago, I worked with it till today. Some hours ago, I've opened my .mdb and I got...Cannot open database 'Dan3.mdb'. I applied Compact&Repair function, but it didn't aid. I've no idea how to extract data from table. I am on MS Access 2010.


    • Edited by LewiMadel Wednesday, March 14, 2018 2:39 PM
    Wednesday, March 14, 2018 2:38 PM

Answers

  • I created some tables in my database some days ago, I worked with it till today. Some hours ago, I've opened my .mdb and I got...Cannot open database 'Dan3.mdb'. I applied Compact&Repair function, but it didn't aid. I've no idea how to extract data from table. I am on MS Access 2010.


    It seems your database is corrupted, if so, visit Google, for example use this one phrase how to repair mdb file corrupt. On it I found guide below or some useful articles, guides, tips...

    http://allenbrowne.com/ser-47.html

    http://allenbrowne.com/recover.html

    https://onlinefile.repair/en/access.html

    Recovering from corruption

    This article may help if your database is already corrupt

    Before doing anything else, make a copy of the corrupted mdb file while Access is NOT running, and without overwriting any earlier backups. This lets you try different approaches and sequences if necessary.

    Next, try the built-in repair utility. This very simple solution may work with corrupted indexes, and might even get rid of a corrupted object:

    If this does not work, follow the steps for the symptoms of your corruption below.


    • Marked as answer by LewiMadel Tuesday, March 27, 2018 6:48 PM
    Sunday, March 18, 2018 6:49 PM

All replies

  • Sounds like it got corrupted somehow. Did you happen to make a backup copy? Otherwise, you might have to try a third-party recovery program.

    Just a thought...

    Wednesday, March 14, 2018 2:45 PM
  • This sounds like a good question for the Microsoft Community. Also note that there are plenty of previous answers to be found.


    Sam Hobbs
    SimpleSamples.Info

    Wednesday, March 14, 2018 2:51 PM
  • What version did you create the database in? You say you are using 2010, but hte file name extension is .mdb which tells me it was created in an earlier version. Did you create the new tables using 2010?
    Wednesday, March 14, 2018 6:36 PM
  • Hello,

    Did you get any error message while opening the database? If it does, please detail the error message so we could get more about the issue.

    Besides, did you update your office recently? What happened "some hours ago"?

    Best Regards,

    Terry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, March 15, 2018 6:27 AM
  • I created some tables in my database some days ago, I worked with it till today. Some hours ago, I've opened my .mdb and I got...Cannot open database 'Dan3.mdb'. I applied Compact&Repair function, but it didn't aid. I've no idea how to extract data from table. I am on MS Access 2010.


    It seems your database is corrupted, if so, visit Google, for example use this one phrase how to repair mdb file corrupt. On it I found guide below or some useful articles, guides, tips...

    http://allenbrowne.com/ser-47.html

    http://allenbrowne.com/recover.html

    https://onlinefile.repair/en/access.html

    Recovering from corruption

    This article may help if your database is already corrupt

    Before doing anything else, make a copy of the corrupted mdb file while Access is NOT running, and without overwriting any earlier backups. This lets you try different approaches and sequences if necessary.

    Next, try the built-in repair utility. This very simple solution may work with corrupted indexes, and might even get rid of a corrupted object:

    If this does not work, follow the steps for the symptoms of your corruption below.


    • Marked as answer by LewiMadel Tuesday, March 27, 2018 6:48 PM
    Sunday, March 18, 2018 6:49 PM