How to Fix Cannot Save Access MDB Database as ACCDB or ACCDE
Question details
The user is unable to convert an older Access .mdb file to the newer .accdb or .accde format because the necessary save command is inactive.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Upgrading or converting an older database format (MDB) to a newer format (ACCDB) in Access 2016.
- Observed behavior
- The Save Object As option is disabled or grayed out, preventing the database from being saved in the ACCDB or ACCDE format.
Make sure your MDB database is not locked or opened in read-only mode by another user, and ensure you have administrative permissions to modify the file.
Configure Default Format and Use Save Database As
This is the most common fix. You need to verify your default format settings and use the correct 'Save As' procedure for the entire database rather than a single object.
In newer versions of Access, the 'Save Object As' command is intended for individual database components (like a specific table or query). To convert the entire database file format, you must use the 'Save Database As' command under the backup section.
Click on 'File' in the top left corner, then select 'Options' at the bottom to open the Access Options dialog box.
Navigate to the 'General' tab. Look for 'Default database format' and ensure it is set to 'Access 2007–2016'.
Click 'OK' to close the options. Go to 'File' and click 'Save As'.
Under the 'Save Database As' section, choose 'Access Database (*.accdb)' and click the 'Save As' button. Specify your file location and click 'Save'.
Perform an Intermediate Format Conversion
If the direct conversion fails due to the file being too old, saving it to an intermediate 2002-2003 format first can resolve compatibility blocks.
Looking for a Lightweight Office Suite? Try WPS Office
While WPS Office does not handle Access database (.accdb) files directly, it is a powerful, free, and lightweight alternative for all your document, spreadsheet, and presentation needs, offering high compatibility with Microsoft Word, Excel, and PowerPoint formats.
- 1. Download the Installer: Visit the official WPS Office website to download the free installation package for your operating system.
- 2. Install WPS Office: Run the downloaded executable file and follow the straightforward on-screen instructions to complete the setup.
- 3. Open Office Files Instantly: Launch WPS Office and directly open your existing Word, Excel, or PowerPoint files with complete format retention.
Frequently Asked Questions
What is the difference between MDB and ACCDB formats?
MDB is the older database format used by Access 2003 and earlier. ACCDB is the newer default format introduced in Access 2007, which supports multi-valued fields, improved encryption, and integration with SharePoint.
Why is the Save Object As option grayed out in Access?
The Save Object As option is generally used for specific items like queries or tables, not the whole database. It can also be disabled if the database is opened in a restricted mode, or if the default database format hasn't been configured to newer versions in Access Options.
Can I convert an ACCDE file back to an ACCDB file?
No, an ACCDE file is a compiled, 'locked down' version of an ACCDB file where the source code is removed to protect the design. You must keep your original ACCDB file if you plan to make structural or code changes later.
