Cannot open database ”. It may not be a database that your application recognizes, or the file may be corrupt.

 

Cannot open database ”. It may not be a database that your application recognizes, or the file may be corrupt.

 

Problem

Running a MS Access macro / query and the following error message appears. This error message is the same if you are adding data to the current Access database or an external access database.

 

Solution

This problem occurs because of one of Microsoft Access’ top features – it’s 2 GB limit (as of June 2012). This error will occur if you are trying to add data (e.g. running an append query, make table query) to the database which would push it over the 2GB file limit.

You have a few solutions available:

1. (Short term) Compact and repair the database you are appending the data to. This should reduce the file size slightly (although it may not be enough!)

2. (Medium term) If the database which has reached it’s 2GB file limit is for holding archived records, consider creating a new Access Database .mdb / .accb to store any future data. The quickest way would be to backup your 2GB file, then rename this to PART2 and delete (followed by a compact and repair) on the original database. This way all your original queries and code will still reference the same database and will not require updating/fixing!

3. (Long term) Stop using MS Access as you’ve now realized that this may not be the best medium for the vast amounts of data you’re processing. Consider using a MySQL database or similar.

 

 

TO REVIEW

Online research shows this message could also occur under the following conditions:

http://support.microsoft.com/kb/310937

2 thoughts on “Cannot open database ”. It may not be a database that your application recognizes, or the file may be corrupt.

  1. Adam Gorge

    One another cause of this error is Access file corruption. We can also use Compact and repair command to repair corrupt access file. But in some cases, this inbuilt utility get failed to repair corrupt access database file then to resolve this error, you should use third party Access Repair Software. Stellar Phoenix Access Repair is one of the best tool!!

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *