Document Editing Problems

Fix Missing Design View for a Microsoft Access Form

Nimra MalikNimra Malik Nov 20, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Find the source file

Locate the original editable ACCDB or MDB front end, or ask the database owner for it.

2
Open Design View

Open the source file in Access, then right-click the form in the Navigation Pane and select Design View.

3
Make and save changes

Edit the form, report, or VBA as needed, then use Save to retain the changes in the master database.

4
Create a new distribution file

If an ACCDE is needed for distribution, use File > Save As > Save Database As and select Make ACCDE in a compatible version of Access.

Edit the form in the original Access master database
If the source is already editable: If the file is an ACCDB or MDB and Design View is unavailable, check which views appear when you right-click the form and investigate any access or design restrictions.
Free Microsoft Office alternative

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.

Open and edit Microsoft Word, Excel, and PowerPoint formats, including DOCX, XLSX, and PPTX.Use a familiar interface for everyday Office tasks.Work with spreadsheets alongside your Access database workflow.Move existing Office documents without starting from scratch.
microsoft office alternative - wps office

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.