Skip to content

Convert ACCDR to ACCDB

Restore an Access runtime database to an editable ACCDB file by renaming a backup copy.

Make ACCDB files online

We can't read ACCDR files yet, so this conversion isn't available. If you can export your work to one of these formats - or others - we'll turn it into ACCDB:

Want to convert ACCDR to ACCDB?

Let us know. We pick the conversions to add next by how many people ask for them.

How to convert accdr to accdb file

An ACCDR database distributed for runtime use must be changed back to ACCDB before it can be designed or maintained in Microsoft Access. The conversion is normally a filename change, not a data export, so it preserves the existing Access database structure.

What the ACCDR format is

.accdr is a deployment extension for a Microsoft Access database. It is usually an .accdb file renamed with the .accdr extension, causing Access to open it in runtime mode.

Runtime mode is intended for people who run an application and enter data but should not use normal design and development commands. Developers commonly distribute ACCDR files with Microsoft Access Runtime or with the full desktop version of Access configured to run the database as an application. The extension is not strong security: an ordinary ACCDB renamed to ACCDR can usually be changed back by anyone who has write access to the file.

What the ACCDB format is

.accdb is the standard Microsoft Access database format introduced with Access 2007. It can contain tables, queries, forms, reports, macros, attachments, multivalued fields, and VBA modules.

Use ACCDB when the database must be opened in the full desktop version of Microsoft Access for design changes, maintenance, importing, exporting, or development. ACCDB does not support the older MDB workgroup security model, although it supports features unavailable in older MDB databases.

How to convert ACCDR to ACCDB

Rename a copy in Windows

  1. Close the database and copy database.accdr to a backup location.
  2. In File Explorer, display extensions by selecting View → Show → File name extensions. The exact menu labels vary by Windows version.
  3. Rename the copy from database.accdr to database.accdb.
  4. Accept the warning that changing the extension might make the file unusable.
  5. Open the renamed copy with the full desktop version of Microsoft Access. Microsoft Access Runtime alone cannot provide the design features needed for editing.

For an ACCDR created from an ACCDB, renaming is normally the complete conversion because both extensions refer to the same Access database structure. Test the copy before replacing the original.

Save an additional ACCDB copy in Access

After opening the renamed file in full Access, use File → Save As → Save Database As → Access Database (*.accdb) if that command is available in the installed Access version. This creates another copy; it does not recover features that were already compiled or removed.

Online converters and desktop alternatives

A web converter is generally unnecessary and is a poor fit for this format. Renaming does not require a conversion service, and uploading the file can expose records, credentials, personal data, linked-table settings, and VBA code. Online services also cannot reliably preserve Access-specific forms, reports, macros, references, or linked data. Use Microsoft Access on Windows for the conversion; Access Runtime and general database tools such as LibreOffice Base are not reliable replacements for full Access when preserving an application.

Compatibility and quality limits

For a normal ACCDR made from an ACCDB, changing the extension does not alter records, tables, queries, forms, reports, attachments, or VBA. It does not reduce file size, remove passwords, decrypt data, or permanently remove runtime restrictions from an independently secured database.

If the source was an .accde renamed to .accdr, changing it to .accdb will not restore editable forms, reports, or VBA source code. ACCDE objects remain compiled, and the original ACCDE must be retained if that is the available source.

Access 2007 and later generally open ACCDB files, but newer database features, references, ActiveX controls, or VBA dependencies may require a later Access release. After the rename, test startup macros, VBA references, linked-table paths, external data connections, forms, reports, and user permissions. If Access reports corruption, restore the backup and run Database Tools → Compact and Repair Database on a copy.

ACCDR vs ACCDB: format comparison

How the ACCDR and ACCDB formats compare on the properties that matter most for this conversion.

Comparison of the ACCDR and ACCDB file formats
Property .ACCDR Microsoft Access Runtime Database .ACCDB Microsoft Access Database
Plain-text readable — No
Data types Typed Typed
Nested structures Yes Yes
Formulas Yes —
Multiple tables or sheets Yes Yes
Typical file size Large Medium
Open standard No No
Best used for Editing and post-production Data exchange
Introduced 2007 2007
Developer Microsoft Microsoft
MIME type — application/vnd.ms-access

Information about file extensions and file types is provided by File-Extensions.org

Already downloaded

This file has already been downloaded. For your privacy it was deleted from our server right after the download, so it cannot be downloaded again. To get it once more, convert the file again.