Office Apps Crashing

Fix an Access 2007 MDB File That Closes on Windows 10

Nimra MalikNimra Malik Nov 20, 2026 870 views

Question details

Find why an Access 2007 MDB database closes on Windows 10 and restore its switchboard and linked-table access.

Fix an Access 2007 MDB File That Closes on Windows 10
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.
Before you start

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.

Solution 1Recommended

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.

1
Open without startup actions

Close Access, then hold Shift while opening the MDB file. Keep holding it until the database opens to bypass startup options.

2
Check the network drive

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.

3
Relink the tables

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.

4
Retest startup

Close the database and reopen it normally. If Access still closes, reopen it with Shift and inspect the switchboard and startup settings.

Bypass startup and restore linked-table paths
A drive letter may not be the whole problem: Restoring L: can resolve a broken path only if it points to the expected share and the current Windows account has permission to access it.
Free Microsoft Office alternative

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.

Review and edit data exported from Access to a spreadsheetCompatible with Microsoft Excel XLSX and XLS filesFamiliar spreadsheet interface for an easier transitionFree, lightweight tools for common office tasks
microsoft office alternative - wps office

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.