locked
Can't open accdb file RRS feed

  • Question

  • Hi,

    I have 1.2 G accdb file and can't open it. It says No Response when click it. No backup file could use.

    Any comments?

    Thanks!

    Thursday, March 8, 2018 1:41 PM

All replies

  • Before playing around with it, make a backup copy.

    What happens if you open Access and navigate to open the file through the application itself?

    You could also try using 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


    Thursday, March 8, 2018 2:04 PM
  • Click the file: No response.

    Open the Access 2016 launch the file Het: The last time you opened accaca.accdb, It caused a serious error. Do you want open it Show Help:  This error may appear if you attempt to open a file marked as damaged or disabled by a Microsoft Office program. Each time the file is opened, even if the file was recovered or repaired, this error appears and other open files or programs will be suspended.

    I try the command line like:

    path to \MSACCESS.EXE   "C:\abcd.accdb"/compact

    Open Access then say No Response,

    • Edited by Daphne1212 Thursday, March 8, 2018 3:30 PM
    Thursday, March 8, 2018 2:37 PM
  • See Bypass startup options when you open a database - Access. That probably won't help but it should be attempted.


    Sam Hobbs
    SimpleSamples.Info

    Thursday, March 8, 2018 8:26 PM
  • No attempt the file. Got file attempted through remove form the disable list setting in the Access option. Got same message. This error may appear if you attempt to open a file marked as damaged or disabled by a Microsoft Office program. Each time the file is opened, even if the file was recovered or repaired, this error appears and other open files or programs will be suspended.
    The file is in the Disabled Items list because, in previous attempts to open the file, it has caused a program error or shut down more than once.
    If the file was properly recovered, replaced, or deleted, you can remove the file from the list of disabled files (re-enable the file) by clicking the File tab, clicking Options, and then clicking Add-Ins. In the Manage list, click the arrow and select Disabled Items, click Go, and then select the disabled item that you want to re-enable.
    Re-enabling a file does not guarantee the application can open it. The file must be recovered from either a backup or undamaged recovered file.
    Thursday, March 8, 2018 8:50 PM
  • Open the Access 2016 launch the file Het: The last time you opened accaca.accdb, It caused a serious error. Do you want open it Show Help:  This error may appear if you attempt to open a file marked as damaged or disabled by a Microsoft Office program. Each time the file is opened, even if the file was recovered or repaired, this error appears and other open files or programs will be suspended.

    So, did you try and open it after the message?

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

    Thursday, March 8, 2018 10:07 PM
  • Yes, Hang on 10 min. Final No Response.
    Thursday, March 8, 2018 10:12 PM
  • Hi Daphne1212,

    You mat try to refer point number 4 to 7 from link below may help you to restore your database.

    How to troubleshoot and to repair a damaged Access 2002 or later database

    Below are the same points I taken from the link.

    1. try creating a new database and importing the objects, one-by-one, from the old database to the new one. Then re-create the relationships. This technique resolves problems with damaged system tables in the database.

      Note You cannot import data access pages with the Import Wizard. Instead, open an existing data access page in the new database. To do so, follow these steps:
      1. In the Database window, click Pages under Objects.
      2. Click New.
      3. In the New Data Access Page dialog box, click Existing Web page, and then click OK.
      4. In the Locate Web Page window, browse to the location of the data access page.
    2. If the damage is in a table, and the previous steps have not recovered the table, try the following:
      1. In Microsoft Access, export the table to an ASCII (delimited text) file. For more information view the topic "Export data or database objects." in Microsoft Access Help.
      2. Delete any relationships associated with this table, and then delete the table from the database.
      3. Compact the database.
      4. Re-create the table and any relationships it had.
      5. Using a word processor, examine the ASCII file for bad or strange data and remove those records. Save the file in an ASCII text file format.
      6. Re-import the ASCII file into the newly re-created table. For more information about this topic, search the Microsoft Access Help Index for the word "delimit" and then view the topic "Import or link data and objects."
      7. Re-enter any records that you were forced to delete.
    3. If the damage is in a form or a report, the damage can be either in the form or the report itself or in one or more controls on the form or the report. You can delete the form or report and import it from the backup copy of your database or use one of the following options:
      • If the damage is in the form or report itself, create a new form or report, and then copy the controls from the original form or report.
      • If the damage is in a control on the form or the report, create a new form or report, and then re-create the controls on the new form or report. It is best to re-create all the controls, because there is no way to tell which controls are damaged.
    4. If the damage is in a macro or a module, the damage can be in the macro or the module itself or in the contents of the macro or the module. You can delete the macro or the module and import it from the backup copy of your database or use one of the following options:
      • If the damage is in the macro or module itself, create a new macro or module, and then copy the contents of the original macro or module.
      • The damage could involve non-ASCII characters embedded in the module. Save the module as a text file, remove any bad or strange data, and then reload the text file into a new module.
      • If the damage is in the contents of the macro or module, you must create a new macro or module, and then re-create the contents of the original macro or module.
    If you cannot repair the database with these steps, the database is probably damaged beyond repair. If this is the case, you should restore your last backup database or re-create the database.

    As a final alternative, some consultants may provide a Microsoft Access database repair service. Because this is such a specialized service, the most efficient way to locate a consultant is to post a message in the Microsoft Access "Third Party and User Groups" Internet newsgroup, which has the following newsgroup address:

        microsoft.public.access.3rdpartyusrgrp

    Regards

    Deepak


    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, March 9, 2018 3:08 AM
  • Create the new database Import Wizard doesn't work.  Also no found the existing data access page in Access 2016?

    Friday, March 9, 2018 2:01 PM
  • The file is probably too big or too corrupt to open. One thing you can try is to get the free SQL Server Express edition and import the tables. You might not be able to import them but it's worth a try. All the other objects might be lost forever.

    Another thought...Can you open a new, blank Access database and link to the tables? If you can, you can make new tables in the new database and insert the data from the linked tables. Then delete the data in the linked tables. That would free up space in the old database and might allow you to compact it with the switch Daniel gave you.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Friday, March 9, 2018 5:36 PM
  • The database is 1.1 gb and can't be tempted in any way.Import / Link doesn't work and show No Response.
    Friday, March 9, 2018 6:23 PM
  • You could SQL Express and import the data there. Just to see if it valid. 

    Another way is open MS-Word and <g class="gr_ gr_12 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" data-gr-id="12" id="12">do</g> a word merge. This is to only verify that the data itself isn't corrupted.

    I think MS-Access itself has a limit on the file size which is causing this issue. MySQL and Oracle Express can import MS-Access files as well if you don't want to use MS Express.

    Glenn Bowlsby



    • Edited by Broggy69 Friday, March 9, 2018 9:08 PM Bad formatting
    Friday, March 9, 2018 8:13 PM
  • The database is 1.1 gb and can't be tempted in any way.Import / Link doesn't work and show No Response.
    Sounds like it's pretty much dead in the water. If my suggestion to use SQL Server Express doesn't work my only other suggestion is to use a third-party to recover the data. My first choice would be Everything Access

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Friday, March 9, 2018 8:23 PM
  • Check if you are trying to open a newer database file using an older version of Access or the file you are trying to access has been corrupted. As you said you don't have any backup file, So you can try Access Recovery Software to view large or corrupted accdb file.
    Saturday, March 10, 2018 9:32 AM
  • Hi Daphne1212,

    Does this Access database was created in Access 2016 version?

    If not, You can try to open in the same version in which it was created.

    Regards

    Deepak


    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, March 12, 2018 1:25 AM
  • YES. this Access database was created in Access 2016 version.
    Monday, March 12, 2018 5:16 PM
  • Hi

    Have you tried to open the database by MS Access 32 bit and also 64 bit?


    Best // Peter Forss Stockholm GMT &#43;1.00

    Monday, March 12, 2018 6:40 PM
  • Hi Daphne1212,

    At present it looks like your database get damaged beyond repair.

    Then also as a last try you can try to use a VBA code to open the database and check whether it get open by code or give any error.

    If it get open then you may try to retrieve some data from it.

    Regards

    Deepak


    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.

    Tuesday, March 13, 2018 5:36 AM