none
MS ACCESS and Cannot open database ". it may not be database that your application recognizes.. RRS feed

  • Question

  • Hi folks,

    I'm getting the error shown below after loading 2175630 rows of data into this one table. 

    "Cannot open database ". it may not be database that your application recognizes, or the file may be corrupt."

    It is size related it seems like, since I opened a new Access DB and loaded up couple of Excel Files and I did not get

    this error. 

    Could you please let me know what could be the "ROOT CAUSE" and any recommendations you may have?

    Thank you!

    Wednesday, November 6, 2019 8:30 PM

Answers

  • What is the file size of the corrupt database?  Access has a 2GB limit and that include the space it needs to perform operations.  So if you db was say 700MB and you need to import large amounts of data and to do so, the queries... require another 1.4GB then your db comes to a crashing halt.

    Try the operation again and during the process, track the file size in Windows Explorer.

    Try importing the data in batches.

    Is it just one particular row of data?  Try omitting it.


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

    • Marked as answer by GoMSACCESS Thursday, November 7, 2019 12:50 AM
    Wednesday, November 6, 2019 8:49 PM

All replies

  • What is the file size of the corrupt database?  Access has a 2GB limit and that include the space it needs to perform operations.  So if you db was say 700MB and you need to import large amounts of data and to do so, the queries... require another 1.4GB then your db comes to a crashing halt.

    Try the operation again and during the process, track the file size in Windows Explorer.

    Try importing the data in batches.

    Is it just one particular row of data?  Try omitting it.


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

    • Marked as answer by GoMSACCESS Thursday, November 7, 2019 12:50 AM
    Wednesday, November 6, 2019 8:49 PM
  • Thank you Daniel,

    You were right. I dropped one of the tables and ran the Compact on the data and saved. Now, I can upload

    the file spreadsheet without any issues.

    So, I'm curious what is our option since we are running short of space that MS Access DB can handle? Any ideas? 

    Thanks so much!

    Thursday, November 7, 2019 12:55 AM
  • So, I'm curious what is our option since we are running short of space that MS Access DB can handle? Any ideas? 

    Hi GoMSACCESS,

    You can make an additional BE for (each) large tables.

    Imb.


    • Edited by Imb-hb Thursday, November 7, 2019 8:35 AM type
    Thursday, November 7, 2019 7:45 AM
  • My question is why are you running out of space.  I've developed numerous database that are used daily by 50+ employees and not one is nearing the 2GB limit.  So what is in yours that is causing you to near the limit?

    The No. culprit normally is attachments.  It is not a good idea to use attachment fields, EVER!  You can learn more at http://www.devhut.net/2016/10/03/adding-attachments-to-an-access-database/

    Beyond that, you can split your data/tables into multiple back-end files.  But this is normally just a band-aid.

    Another option is to switch your back-end to SQL Server or SQL Server Express.


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

    Thursday, November 7, 2019 10:55 AM