Fix an Access 2007 MDB File That Closes on Windows 10
Question details
Find why an Access 2007 MDB database closes on Windows 10 and restore its switchboard and linked-table access.

- Product
- Microsoft Access 2007
- Device & OS
- Windows 10
- Scenario
- An MDB database that opens on Windows 7 is being used on a Windows 10 computer after a system reinstall.
- Observed behavior
- Access closes when the database opens normally or when the switchboard is selected. Holding Shift while opening the file bypasses startup and allows the database to open.
Identify the database's original network locations and confirm you have access to any shared folders. Note which mapped drives, such as L:, are missing or point to different locations on Windows 10.
Bypass startup and restore linked-table paths
Use this approach when the database opens with Shift but its linked files or mapped drives may have changed.
Close Access, then hold Shift while opening the MDB file. Keep holding it until the database opens to bypass startup options.
In File Explorer, check whether drive L: and any other required drives open the expected shared folders. If a drive is missing, use This PC > Map network drive and reconnect it to the correct network share using an account with access.
In Access, open Linked Table Manager from the Database Tools tab. Select the linked tables, choose to always prompt for a new location if needed, and browse to the correct source database or files.
Close the database and reopen it normally. If Access still closes, reopen it with Shift and inspect the switchboard and startup settings.

Inspect the switchboard and startup configuration
Use this method if selecting the switchboard still closes Access after linked paths are corrected.
Repair and test the MDB database
Try this if corrected paths and switchboard settings do not stop Access from closing.
Work with exported Access data in WPS Office
WPS Office is a free, lightweight alternative for everyday documents and spreadsheets, with a familiar interface and compatibility that makes moving Office files straightforward. Export Access data to Excel first; WPS does not repair MDB databases or run Access switchboards.

Frequently Asked Questions
Why does the MDB file open when I hold Shift?
Holding Shift while opening the database bypasses startup options, which suggests that a startup form, macro, or related action may be involved. It does not identify the exact cause on its own.
How do I change a broken linked-table path?
Open the database while holding Shift, then use Database Tools > Linked Table Manager to select the affected tables and browse to their current source files.
What should I do if drive L: is unavailable?
In File Explorer, use This PC > Map network drive to reconnect L: to the correct share. Confirm that the current Windows account can access the folder, then check the linked tables in Access.
Where is the switchboard path stored?
It depends on the database. Check the switchboard form in Design View, its event macros and VBA code, and the linked-table locations. The startup form is selected under Office button > Access Options > Current Database.
Can WPS Office fix or run my Access switchboard?
No. Use Microsoft Access to troubleshoot the MDB and its switchboard. You can export data from Access to Excel and open the resulting spreadsheet in WPS Office.




