Cannot open database ”. It may not be a database that your application recognizes, or the file may be corrupt.
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.
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.
Online research shows this message could also occur under the following conditions: