Fix Missing Design View for a Microsoft Access Form
Question details
The user needs to edit an Access form but cannot find or use Design View.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A database has been split or distributed, and the user wants to change a form, report, or VBA code.
- Observed behavior
- Forms, reports, and VBA cannot be edited in an MDE or ACCDE database, although tables and queries may remain available.
Check the database file extension and locate any editable master or unsplit database. In Access, right-click the form in the Navigation Pane to see whether Design View is available.
Edit the form in the original Access master database
Use the editable source database when the distributed file is an ACCDE or MDE.
ACCDE and MDE files prevent design changes to forms, reports, and VBA. Editing requires the original source database, typically an ACCDB for an ACCDE or an MDB for an MDE.
Locate the original editable ACCDB or MDB front end, or ask the database owner for it.
Open the source file in Access, then right-click the form in the Navigation Pane and select Design View.
Edit the form, report, or VBA as needed, then use Save to retain the changes in the master database.
If an ACCDE is needed for distribution, use File > Save As > Save Database As and select Make ACCDE in a compatible version of Access.

Rebuild the front end when the master file is unavailable
Use this approach if you cannot obtain an editable source database.
Work with Office documents in WPS Office
WPS Office is a free, lightweight alternative for everyday documents, spreadsheets, and presentations. Its familiar interface and Microsoft Office format compatibility make it easy to move existing files. It does not edit Access databases or restore form design code.

Frequently Asked Questions
Why is Design View missing for my Access form?
The database may be an ACCDE or MDE file, which prevents changes to form and report designs and VBA. Check the file extension and right-click the form in the Navigation Pane to see the available views.
Can I convert an ACCDE back into an editable ACCDB?
An ACCDE does not retain the design information and VBA source needed for normal editing. Obtain the original ACCDB master or recreate the front end instead.
Can I still use the tables in a compiled database?
Tables and queries may remain available in an ACCDE or MDE. Check the Navigation Pane and, for a split database, identify the back-end file before linking tables to a new front end.
Will creating another ACCDE restore Design View?
No. Creating or recompiling a compiled database does not restore removed design information. Make changes in the original editable master before creating a new ACCDE.




