Troubleshoot Microsoft Access Runtime Forms That Do Not Open
Question details
Identify why a form appears blank or fails to open in an Access Runtime or ACCDE deployment.

- Product
- Microsoft Access and Access Runtime
- Device & OS
- not provided
- Scenario
- An application opens a splash screen and then attempts to display a login or another form in an ACCDE deployment.
- Observed behavior
- A form may appear blank or the application may stop progressing past the splash screen, even when an On Open message appears.
Locate the original editable ACCDB and open it in the full version of Access; an ACCDE does not allow you to edit form design or VBA code. Note which startup event or form is the last to run before the problem occurs.
Check the form and its record source in the original database
Use this method to distinguish a form design or data problem from a Runtime deployment problem.
In the original ACCDB, open the form directly from the Navigation Pane. If startup code prevents access, try holding Shift while opening the database, provided the bypass key has not been disabled.
Open the form in Design View, press F4 to display the Property Sheet, and check Record Source on the Data tab. Open the referenced table or query directly and confirm it runs and returns the expected records.
In the form's Property Sheet, check Allow Additions and Data Entry on the Data tab. A form can appear blank when its record source has no records and it cannot display a new record.
In Design View, check that controls are visible and have valid Control Source values. On the Property Sheet's Event tab, inspect On Open and On Load for code or macros that cancel opening or hide controls.

Trace startup events and repair VBA references
Use this method when the application hangs at the splash screen or errors are being suppressed.
Import the form into a fresh database and rebuild the ACCDE
Try a fresh database if the form or source database may be damaged after data and code checks.
Use WPS Office for Spreadsheet and Document Work
WPS Office is a free, lightweight alternative with a familiar interface for everyday documents and spreadsheets. It can help you move compatible Office files into a streamlined workspace, but it cannot run or repair Access ACCDE applications or forms.

Frequently Asked Questions
Why does my Access form open completely blank?
One possibility is that the record source returns no records and the form cannot show a new record. Open the source table or query and check Allow Additions and Data Entry in the form's Property Sheet.
Can I edit the form or VBA code in an ACCDE?
No. Open the original ACCDB in full Access to edit the form or VBA code, then create a new ACCDE using Database Tools > Make ACCDE.
How do I find a missing VBA reference?
In the editable ACCDB, open the VBA editor and choose Tools > References. Look for entries marked MISSING, resolve them, and then choose Debug > Compile.
What should I check if the splash screen does not advance?
Inspect the splash form's On Timer and On Close events in Design View. Add temporary logging to the procedures that check user data and open the next form so you can identify where execution stops.




