Convert ACCDR to MDE

Understanding ACCDR and MDE file formats

ACCDR is a file extension used by Microsoft Access to open a database in runtime mode. This mode restricts users from making design changes, allowing only data entry and basic operations. ACCDR files are essentially renamed ACCDB files, providing a way to distribute databases with limited functionality.

MDE is a compiled version of a Microsoft Access database (MDB format). When a database is saved as an MDE, all modules are compiled, and the source code is removed, preventing users from viewing or editing VBA code and design objects. This format is used for distributing secure, locked-down Access applications.

Why convert ACCDR to MDE?

Converting an ACCDR file to MDE is useful when you want to further secure your Access application by compiling it and removing editable source code. This is especially important when distributing your database to end users who should not have access to design or code elements.

How to convert ACCDR to MDE

Since ACCDR is just a renamed ACCDB file, you must first rename it back to ACCDB before conversion. Then, you can use Microsoft Access to create an MDE file.

1. Rename your .accdr file to .accdb.
2. Open the .accdb file in Microsoft Access.
3. Ensure your database is in Access 2002-2003 file format (MDB), as MDE is not available for ACCDB files. If needed, convert your database: File → Save As → Access 2002-2003 Database (*.mdb).
4. With the MDB file open, go to Database Tools → Make MDE (in older Access versions, use Tools → Database Utilities → Make MDE File).
5. Save the resulting .mde file.

Best software for ACCDR to MDE conversion

The most reliable tool for this conversion is Microsoft Access itself. No third-party converter can fully replicate the compilation and security features provided by Access. Ensure you use a compatible version of Access (2003 or earlier for MDE output).

Summary

To convert an ACCDR file to MDE, rename it to ACCDB, open it in Microsoft Access, save it as an MDB if necessary, and then use the Make MDE feature. This process secures your database for distribution.