Others

Troubleshoot Microsoft Access Runtime Forms That Do Not Open

Elise WilliamsElise Williams Nov 20, 2026 869 views

Question details

Identify why a form appears blank or fails to open in an Access Runtime or ACCDE deployment.

Troubleshoot Microsoft Access Runtime Forms That Do Not Open
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the source form

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.

2
Inspect the record source

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.

3
Check empty-form settings

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.

4
Inspect controls and events

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.

Check the form and its record source in the original database
Check the record count: For a named table or saved query, you can temporarily add MsgBox DCount("*", "YourRecordSource") to a startup event, replacing YourRecordSource with the actual table or query name.
Free Microsoft Office alternative

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.

Work with spreadsheet data when a spreadsheet is suitable for your taskOpen and edit Microsoft Excel XLSX and Word DOCX filesUse a familiar interface for everyday Office tasksMove compatible documents and spreadsheets into a lightweight workspace
QA img-9

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.