Fix VBA and Menu Form Issues in an Access ACCDE File
Question details
Identify why a menu form does not open in an Access ACCDE file when it works in the original ACCDB 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.
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.
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.
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.
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.
If necessary, select Add new location, choose a folder you control, and place the ACCDE there. Reopen the file and test the menu form.

Trace the failing VBA procedure in the source ACCDB
Use error handling and diagnostic messages when VBA runs but the menu form still does not open.
Inspect report images used by the database
Check copied report images if diagnostics point to a report or related object rather than blocked VBA.
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.

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.




