Others

Fix an Access Database That Opens Without Its Main Form

John WilsonJohn Wilson Nov 22, 2026 868 views

Question details

The user needs to find out why an Access database opens without its main form or some tables on certain computers.

Fix an Access Database That Opens Without Its Main Form
Product
Microsoft Access
Device & OS
not provided
Scenario
Users open individual desktop copies of an Access database on different computers.
Observed behavior
The database opens correctly on one computer, but the main form or some tables do not appear on others.
Before you start

On each affected computer, note the exact folder containing the database and whether Access displays a security warning. Confirm that the database comes from a trusted source before enabling its content or adding its folder to trusted locations.

Solution 1Recommended

Check trusted locations and the startup form on each computer

Use this method when the database opens but its main form does not appear automatically.

1
Check the trusted folder

In Access, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations. Confirm that the affected computer's exact desktop folder is listed or covered by a trusted parent folder.

2
Trust the database if appropriate

If the database is from a trusted source, use Add new location to add its folder, or select Enable Content in the security warning when offered. Repeat the check on each affected computer; one computer's trusted locations do not apply to the others.

3
Set the startup form

Go to File > Options > Current Database and select the intended form in the Display Form list. Click OK, then close and reopen the database.

4
Open the form manually

Press F11 to show the Navigation Pane, locate the main form, and double-click it. If it fails to open, check for an error message that may identify a missing reference or data source.

Check trusted locations and the startup form on each computer
Trust locations carefully: Only trust folders and enable content for databases from sources you trust. Adding a folder as a trusted location can allow active content in other databases stored there to run.
Free Microsoft Office alternative

Use WPS Office for Spreadsheet-Based Data Work

WPS Office is a free, lightweight alternative for everyday document and spreadsheet work. Its familiar interface and Microsoft Office format compatibility make it easier to move existing files into WPS. It does not open or repair Access databases or run Access forms and macros.

Work with tabular data in WPS Spreadsheets.Open and save Microsoft Excel XLSX files.Use a familiar interface for common spreadsheet tasks.Move compatible Office documents into a lightweight suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why does the same database work on one desktop but not another?

Trusted locations, Access versions, installed references, and linked table paths can differ between computers. Check each affected computer under File > Options > Trust Center and compare its Access setup with the working computer.

How do I make an Access form open automatically?

In Access, go to File > Options > Current Database, choose the form under Display Form, and click OK. Close and reopen the database to test it.

How can I find tables that are not showing?

Press F11 to open the Navigation Pane. Check its Navigation Options for hidden objects, and use External Data > Linked Table Manager to inspect tables linked to another data source.

Can WPS Office fix or run my Access database?

No. WPS Office does not repair Access databases or run Access forms and macros. It can help with spreadsheet-based work using compatible Excel files.