Fix an Access Database That Opens Without Its Main Form
Question details
The user needs to find out why an Access database opens without its main form or some tables on certain computers.

- 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.
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.
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.
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.
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.
Go to File > Options > Current Database and select the intended form in the Display Form list. Click OK, then close and reopen the database.
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.

Verify linked tables and their data source paths
Use this method if the database is split or forms depend on tables stored in another file.
Check Access compatibility and missing references
Use this method if the startup form still fails or Access reports a code or reference error.
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.

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.




