Recent Posts

Recent Comments

Archives

Categories

Meta

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

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

  1. news

    How come you dont have your website viewable in wap format? cant see anything in my iPhone.

  2. Toby Scamell

    I’ve only just installed WordPress 2 days ago and as you can see have done nothing to the layout due to time constraints! My initial priority was adding the content. The layout and a new custom theme will hopefully be designed next weekend :)

  3. Toby Scamell

    I’ve now updated the site to a new theme and enabled mobile view. Seems to work fine on my iPhone now. Thanks for making me get round to it!!

Leave a Reply