How to Fix the MDE Type Library Error in Access 2016
Question details
Users are encountering a VBA project compilation and library reference error when attempting to open legacy database files in Access 2016.
- Product
- Microsoft Access 2016
- Device & OS
- Windows
- Scenario
- Opening a compiled MDE database file in Access 2016, particularly after installing recent Windows or Office updates.
- Observed behavior
- The application fails to load the file properly and displays the error message: 'Requested type library or wizard is not a VBA project.'
Ensure you have access to the original, uncompiled MDB source file, as compiled MDE files cannot be edited directly to fix VBA reference issues.
Check References and Recreate the MDE File
The most reliable fix is to resolve missing type library references in the original uncompiled database and generate a fresh MDE file.
Because an MDE file is compiled, its VBA code is locked and cannot be modified. To fix reference errors caused by system updates, you must edit the source MDB file.
Launch Microsoft Access 2016 and open the original MDB file used to create the faulty MDE.
Press the ALT + F11 keys simultaneously to open the Visual Basic for Applications (VBA) editor.
In the top menu bar, click on 'Tools' and select 'References'. Look for any items in the list that start with 'MISSING:'.
Uncheck the missing references if they are no longer needed, or browse your system to locate the correct path for the updated library files, then click 'OK'.
Go to 'Debug' > 'Compile', save your changes, and then use the database utilities in Access to create a new MDE file.
Uninstall Problematic Windows Updates
If the error began immediately after a system update, rolling back specific Office security updates may temporarily restore functionality.
Convert the Database to ACCDB or ACCDE Format
MDE is a legacy format that lacks full support in newer Access versions. Upgrading to a modern format prevents compatibility issues.
Upgrade Your General Office Productivity with WPS Office
While resolving complex legacy database issues, you can simplify the rest of your daily workflow. WPS Office is a lightweight, completely free alternative to Microsoft Office that provides robust document, spreadsheet, and presentation tools without the compatibility headaches.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package.
- 2. Install the Software: Run the setup file and follow the straightforward on-screen instructions.
- 3. Start Creating: Open WPS Office to instantly access Writer, Spreadsheet, and Presentation applications.
Frequently Asked Questions
Why can't I edit the VBA references directly in the MDE file?
MDE files are compiled and locked versions of Access databases. The human-readable source code is stripped out to protect intellectual property and improve performance. Therefore, VBA references and code cannot be altered in an MDE file; you must edit the original MDB file instead.
What causes broken references in Access 2016 after a Windows update?
Windows or Office updates may replace, move, or deregister certain system DLLs or ActiveX controls. When Access attempts to load a library from its previous location, the connection fails, resulting in a 'Requested type library or wizard is not a VBA project' error.
Is it absolutely necessary to convert MDB files to ACCDB?
While not strictly mandatory if your current environment still supports it, Microsoft has deprecated the legacy MDB format. Converting to ACCDB ensures long-term compatibility, better security, and access to modern database features in Access 2016 and newer.
