none
In MS Access 2007 was created by some IT specialists great and huge database RRS feed

  • Question


  • It controlled all the data from many other apps. They expended two weeks for this purpose. After they went for a rest on a month. The database worked greatly one week. But yesterday at 6 a.m. it stopped working. We saw a message from Access - Cannot open database 'General.mdb'. It may not be a database that your application recognizes, or the file may be corrupt. The problem that only in a week our tech specs will return. But we have to do something with it right now. We tried to apply Recovery for Access feature from Microsoft, but we didn't get results.

    Sunday, July 1, 2018 1:54 PM

All replies

  • Hello MoraChrista,

    What's the size of the database? Access database have a 2 GB size limit, does the huge database grow up to this limit?

    Have you tried to refer to below document to compact and repair the database?

    Compact and repair a database

    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.

    Monday, July 2, 2018 5:22 AM

  • It controlled all the data from many other apps. They expended two weeks for this purpose. After they went for a rest on a month. The database worked greatly one week. But yesterday at 6 a.m. it stopped working. We saw a message from Access - Cannot open database 'General.mdb'. It may not be a database that your application recognizes, or the file may be corrupt. The problem that only in a week our tech specs will return. But we have to do something with it right now. We tried to apply Recovery for Access feature from Microsoft, but we didn't get results.

    Recovering from corruption

    This article may help if your database is already corrupt or I hope following resources also might be effective, one of it must aid you…

    https://support.microsoft.com/en-us/help/283849/how-to-troubleshoot-and-to-repair-a-damaged-access-2002-or-later-datab

    https://support.microsoft.com/en-us/help/2212418

    https://access.recoverytoolbox.com/

    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:

    • In Access 2010, click Compact and Repair Database on the Database Tools ribbon.
    • In Access 2007, click the Office button (top left), then Manage.
    • In Access 95 - 2003, choose Database Utilities from the Tools menu.

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


    Tuesday, July 3, 2018 5:00 PM
  • Before doing anything whatsoever, make a backup copy of the database.  Only work on copies in case you do more damage trying to recover the data.

    Do you have any backups you could simply restore?

    What about trying to create a new blank database and then try importing everything from the one that does work anymore?  Sometimes that works.

    What about trying the /compact command line switch?



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

    Tuesday, July 3, 2018 5:44 PM
  • Hello mohan8833,

    What's the current state of the thread? If your issue has been solved, I would suggest you mark helpful reply to close the thread or provide your solution and mark it to help more people who runs into the same issue.

    If not, please feel free to let us know if you have any updates for your issue.

    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.

    Friday, July 6, 2018 6:41 AM