Fixing the “Access Cannot Open a Database Created with a Previous Version” Error in Microsoft Access

Many users have reported encountering the “Cannot open a database created with a previous version of your application” error while trying to open MDB database files in Microsoft Access. This issue commonly appears when attempting to access legacy MS Access database files (Access 97) using newer versions such as Access 2013, Access 2016, 2019, or Microsoft 365. In several cases, users have also experienced this error with databases created in Access 2000, 2002, and 2003.

This error generally occurs due to compatibility limitations between older MDB file formats and modern Access versions. In this guide, we’ll explore the primary causes behind the MS Access cannot open database error, along with effective fixes and workarounds to help you open MDB files smoothly without encountering this issue.

Why the Access Cannot open a database Access Error Message Occurs?

According to Microsoft, the above error occurs when users try to open an MS Access 97 database file on newer versions of MS Access (2013 or later). This happens because the recent MS Access versions cannot convert Access 97 files. MS Access 2007 and 2010 use the Database Enhancement Wizard to convert MDB files to ACCDB files. But this is not possible with MS Access 2013.

If you are facing the same error message while trying to open the Access 97 database file, proceed with the workarounds explained below.

Methods to fix the ‘Cannot Open a Database’ Error

The above error message renders the old MS Access database file inaccessible. However, to access its data, you can open the MDB file in Access 2003 and save it in the file format compatible with MS Access 2013. There are also some workarounds that can help you resolve this issue. Let’s look at them in detail.

Workaround 1: Convert MDB to ACCDB File

You can convert the MS Access 97 database (MDB) file to an ACCDB file by opening it using MS Access 2007 or 2010. Here are the steps –

• Launch MS Access 2007/2010 on your PC.
• Click on Tools in the ribbon.
• Go to Database Utilities and click on Convert Database. Select Access 2002-2003 file format.
• You will see a prompt asking for a file name. Enter a name and click Save.
• Close the application.
• Now, open Access 2013 or later.
• Click on File > Save As > Access Database (*.accdb) and click Save As.
• When the Save As screen appears, click Save.

The selected file will be saved as an ACCDB file.

You can also convert MS Access 2000, 2002, or 2003 database (MDB) files to ACCDB files. Here are the steps –

• Launch MS Access and click on File > Open.
• Locate and select the MS Access 2000 database file you want to convert.
• After the selected database files opens, click on File > Save & Publish.
• Click on Save Database As > Select Access base > Save As.

The database will be saved in Access 2007 database format.

Workaround 2: Open Specific Database Elements

If you are getting the above error message while trying to open a database element, like a table, made using Access 97 or 2000. Simply open it in a later version of the corresponding MS Office software like MS Excel. Here is what to do –

• Open a new worksheets
• Go to the Data tab.
• Click on the From Access menu item.
• Select the database’s .mdb file.
• In the Data Link Properties box that opens, switch to the Provider tab.
• Select the Microsoft Jet 4.0 OLE DB Provider.
• Click on Next.
• Reselect the database’s .mdb file (it forgets it when you change Provider).
• Click OK.
• From the Select Table dialogue that appears, choose the table you want to import.

In this way, you can fix the Cannot open a database error message.

An Easy Way to Fix Access Database File Corruption

If converting the Access database, the MDB file to the ACCDB file didn’t help you open it. Then, it could be file corruption. To repair Access database corruption, you will need to repair the database using the Access inbuilt Compact and Repair utility feature. But if the Compact and Repair utility fails to eliminate the error message, use an Access repair tool to restore the database.

For this, you can go with Stellar Repair for Access – a reliable software that you can use to repair a corrupted MDB/ACCDB file. The software repairs the file and provides a preview of the recoverable file data. Once you’ve verified the data, you can save the repaired file. The detailed steps are as follows –

• Download and Install Stellar Repair for Access from its official website.
• Launch it.
• The Select Database window will appear. Click on Browse to locate the corrupt Access database file. You can also click on Search if you don’t know the folder where you have kept the corrupt MDB file.
• Select the MDB database file you want to open and then click on Repair.
• When the Repairing Complete message box appears, click OK.
• Check the preview of the data you can extract from the repaired file.
• Once satisfied with the preview, select the Save Database option in the File section.
• When presented with a Save At dialog box, select the location containing the New Folder option to choose the location of the repaired file. 
• Click OK to proceed.

Navigate to the location where you have saved the file, open it, and access its data.

Conclusion

If you are encountering the ‘Cannot open a database created with a previous version’ error message when opening an old MDB database file, try the workarounds discussed in this post. Converting the MDB file to the ACCDB file should help you eliminate the error. However, if you are unable to open the MDB file after converting it to ACCDB, then the MDB file could be corrupt. In such a scenario, you can use Stellar Repair for Access to resolve Access database corruption and recover its data. The software can recover tables, macros, modules, forms, and other objects from a corrupted Access database file.