VBA & Macro Problems

Fix VBA and Menu Form Issues in an Access ACCDE File

Steven ParkerSteven Parker Nov 14, 2026 868 views

Question details

Identify why a menu form does not open in an Access ACCDE file when it works in the original ACCDB file.

Fix VBA and Menu Form Issues in an Access ACCDE File
Product
Microsoft Access
Device & OS
not provided
Scenario
An Access database is distributed as an ACCDE file, and its startup menu form should open as it does in the source ACCDB.
Observed behavior
The menu form fails to open in the ACCDE file, although it opens in the original ACCDB.
Before you start

Locate the original ACCDB source file and confirm which Access version or runtime is used to open the ACCDE. You will need the ACCDB to modify VBA code or database objects and create a new ACCDE.

Solution 1Recommended

Check whether the ACCDE is in a trusted location

Use this check when Access may be blocking VBA or other active content in the database.

1
Check for a security warning

Open the ACCDE in Access and look for a security warning. If the file is from a source you trust, select Enable Content if that option appears.

2
Review trusted locations

In the full version of Access, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations. Check whether the folder containing the ACCDE is listed.

3
Trust a safe folder

If necessary, select Add new location, choose a folder you control, and place the ACCDE there. Reopen the file and test the menu form.

Check whether the ACCDE is in a trusted location
Trust only safe locations: Files in a trusted location can run active content without the usual warnings. Do not add a shared or untrusted folder.
Free Microsoft Office alternative

Use WPS Office for Everyday Office Documents

WPS Office is a free, lightweight alternative with a familiar interface for working with documents, spreadsheets, and presentations. It supports common Microsoft Office formats to make moving everyday files easier, but it does not fix Access VBA or run ACCDE databases.

Work with everyday Office files in a familiar interfaceOpen and edit common Microsoft Office formats, including DOCX, XLSX, and PPTXUse a free, lightweight office suite alongside your Access database
microsoft office alternative - wps office

Frequently Asked Questions

Why does the ACCDB work when the ACCDE menu form does not?

The ACCDE may be opened from a different location or environment, or an error may occur in compiled code or a database object. Check for a security warning, verify the trusted location, and add diagnostics to the source ACCDB before rebuilding the ACCDE.

Where do I add an Access trusted location?

In the full version of Access, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations, then select Add new location. Only trust folders whose contents you control.

Can I edit VBA directly in an ACCDE file?

No. Open the original ACCDB in the full version of Access, edit and compile the VBA there, and then create a new ACCDE.

How can I see errors when testing with Access Runtime?

Add an error handler with a MsgBox or another logging method in the source ACCDB, rebuild the ACCDE, and test it in Access Runtime. The message can identify the procedure and error encountered.

Could a report image stop the menu form from opening?

It can be relevant if the startup process encounters the affected report or object. In the reported case, removing a copied filter image from a report fixed the issue; inspect and retest suspect images in the source ACCDB.