How to Fix Access Previous Version Database Error
Question details
The user is unable to open an older Access database (.mdb) in Access 2013 or later due to a previous version compatibility error.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Opening an older .mdb database file in a newer version of Microsoft Access (2013 or later).
- Observed behavior
- Access displays an error stating that the database was created with a previous version and refuses to open the file.
Ensure you have access to an intermediate version of Microsoft Access, such as Access 2007 or 2010, as you will need it to perform the file conversion.
Convert the Database to ACCDB Format Using Access 2007 or 2010
Use an intermediate version of Microsoft Access to upgrade the older .mdb file to the modern .accdb format supported by newer versions.
Microsoft Access 2013 and later versions no longer support opening databases created in Access 97 or earlier. To resolve this, you must first open the file in a version of Access that still supports the older format (like Access 2007 or 2010) and save it as an .accdb file.
Launch Microsoft Access 2007 or 2010 and open your older .mdb database file.
Click on the 'File' tab (or the Microsoft Office Button in Access 2007) and select 'Save As'.
Under the 'Save Database As' section, choose 'Access Database (*.accdb)' and click the 'Save As' button.
Choose a destination folder, enter a name for your new database, and click 'Save'. You can now open this new file in Access 2013 or later.
Looking for a Lightweight Office Suite? Try WPS Office
While Microsoft Access handles complex databases, for your everyday document, spreadsheet, and presentation needs, WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office. Enjoy a familiar interface and seamless migration without the hefty subscription fees.
- 1. Download WPS Office: Visit the official WPS website and click the free download button for your operating system.
- 2. Install the software: Run the downloaded installer and follow the simple on-screen instructions to complete the setup.
- 3. Open your documents: Launch WPS Office and instantly open your existing Word, Excel, or PowerPoint files with perfect formatting.
Frequently Asked Questions
Why does Access 2013 or later show a previous version error?
Starting with Access 2013, Microsoft removed support for older database formats like Access 97 (.mdb). When you try to open these legacy files, the software blocks them and displays a previous version error.
Can I convert an MDB file without an older version of Access?
There is no built-in way to convert an Access 97 MDB file using only Access 2013 or later. You must either use an intermediate version like Access 2007/2010, or rely on specialized third-party database conversion software.
What is the difference between MDB and ACCDB formats?
MDB is the legacy database format used by Access 2003 and earlier. ACCDB is the newer, default format introduced in Access 2007, which supports advanced features like multi-valued fields, attachment data types, and improved encryption.
