MS Access also known as MS Office Access is the database management system developed by Microsoft. It combines graphical-user-interface (GUI) and few other software development programs. It is used in as a Database Management System by most of the MNC’s and big organizations. But it doesn’t mean that it doesn’t throw error message.
“Cannot open database” It may not be a database that your application recognizes, or the file may be corrupt.
This is the most common error that is found by the Access users.
Take practical example:
I am not doing anything out of the standard of importing data, and running a few queries. It works find for a little while, but then it decides to give this message. (Cannot open database ”. It may not be a database your application recognizes, or the file may be corrupt.) I am not doing anything but importing a text file, trying to export a text file from a query or table, trying to append data from one table to another etc. Once this error happens the database being use becomes useless and no amount of compacting and repair seems to help.
I have worked with this application for 10 years and never seen this happen. I tried a re-install and still no luck. Any point in the right direction would be greatly appreciated. ——– RobP76 asked on Microsoft
Running the MS Access macro / query or adding any data to current Access database or to the external access database and the above given error message appears.
Here you have the Solution
This problem generally occurs due to one of the Microsoft Access’ top features which is 2 GB limit. This error occurs when you are adding new data to the database that push it over 2GB file limit.
Don’t worry you have the got the solution for the above problem.
Few solutions available:
1. Compact and repair your database to the added the data. It will reduce the file size limit slightly though it is not the long term solution but still for a while you can manage it.
2. If your database has reached 2GB file limit for the holding archived records then consider a new Access Database .mdb / .accb to keep the rest of the data or for some other new data. Well it’s too not a long term solution but you can go with it. The best way is to backup your 2GB file and rename it to PART2 and delete the original database. Through this way all your original queries and code will still refer the same database and won’t need ay fixing or update.
3. Stop using MS Access well this is worst solution how can you leave a database just because a simple error message. Well in that case the last and most powerful solution left with you is to use third party tool. Access Repair Tool is the most powerful tool that is designed to fix any sort of corruption, damaged or inaccessible issue that occurs in your database.
steps to fix error:
Step 1:Download and install Stellar Phoenix Access recovery software.
Step 2: Just click on “Open MS access file” button on the toolbar. You will find a pop-up window from where you can search or select for an ‘.mdb’/’.accdb’ file in your PC.
Step 3: Look at the image below you will find same image in your computer screen. With the help of this “Customers” table you will be able to view both the data and column information.
Step 4:Preview the column information of “Employees” table.
Step 5: Now you will the preview of database query.