File Format & Compatibility

Can You Edit an ACCDE File in Microsoft Access?

Kushani NimanthikaKushani Nimanthika Nov 20, 2026 868 views

Question details

The user wants to know whether an ACCDE database can be edited and how to make design changes.

Can You Edit an ACCDE File in Microsoft Access?
Product
Microsoft Access
Device & OS
not provided
Scenario
The user needs to update forms, reports, modules, or VBA code in a compiled Access database.
Observed behavior
Design View and object creation may be unavailable for compiled database objects.
Before you start

Ask the database developer or owner for the original ACCDB source file. If the database is split, identify both the front-end source and the back-end data file before making changes.

Solution 1Recommended

Edit the ACCDB source and create a new ACCDE file

Use the original source database to change protected objects, then distribute a newly compiled ACCDE.

An ACCDE is a compiled database that prevents design changes to forms, reports, and modules. You need the original ACCDB source to modify those objects or their VBA code.

1
Open the source database

In Microsoft Access, select File > Open and choose the original ACCDB file, rather than the ACCDE file.

2
Prepare a split database

If the database is split, work with copies of the development front end and back end. In the front end, use External Data > Linked Table Manager to relink its tables to the copied back end for testing.

3
Make and test changes

Open the required forms or reports in Design View, or open the VBA editor to update code. Test the changes in the ACCDB before compiling.

4
Create the ACCDE

In Access, select File > Save As, choose Make ACCDE, and save the new file. The exact menu labels may vary by Access version.

5
Check links and distribute

For a split database, use Linked Table Manager to ensure the front end points to the intended production back end. Distribute the new ACCDE front end to users.

Edit the ACCDB source and create a new ACCDE file
If the source is unavailable: Contact the original developer or database owner for the ACCDB. The compiled ACCDE does not provide the original editable form, report, and VBA designs.
Free Microsoft Office alternative

Review exported Access data in WPS Spreadsheet

WPS Office is a free, lightweight alternative for working with exported database data. Its familiar spreadsheet interface and Microsoft Office format support make it easy to move from Excel, but it cannot edit ACCDE database designs or replace Microsoft Access.

Review and analyze Access data exported to a spreadsheetOpen and edit Microsoft Excel XLSX filesUse a familiar interface for an easier transition from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can I change data in an ACCDE file?

Often, yes. You may be able to add or edit records through tables or forms if the database, data source, and your permissions allow it. The ACCDE restriction primarily protects compiled object designs and VBA code.

Can I edit an ACCDE form in Design View?

No. Open the original ACCDB source in Access and edit the form in Design View there, then create a new ACCDE.

What if I cannot find the original ACCDB file?

Ask the database developer or owner for the source. Without it, you cannot directly edit the compiled form, report, or VBA designs in the ACCDE.

Can WPS Office open an ACCDE database?

WPS Office does not replace Access for opening or editing ACCDE databases. If you have access to the data in Access, use External Data > Export > Excel and open the exported XLSX file in WPS Spreadsheet.