Fix Microsoft Access SQL Server ODBC Login Timeout After Startup
Question details
Resolve an initial ODBC login timeout when an Access MDB front end connects to linked SQL Server tables after Windows starts.

- Product
- Microsoft Access and SQL Server ODBC driver
- Device & OS
- Windows
- Scenario
- An Access MDB front end uses SQL Server linked tables and a user DSN with Windows authentication.
- Observed behavior
- The first launch after a restart times out and displays a trusted-connection dialog, while later launches and the DSN test succeed.
Confirm the SQL Server name, authentication method, and location of the MDB file. Check that the SQL Server ODBC driver installed on the workstation matches the bitness of Access.
Relink the SQL Server tables using a file DSN
Use this method to refresh linked-table connection information and avoid relying on a workstation-specific user DSN.
Open ODBC Data Sources on Windows, choose the File DSN tab, and select Add. Choose the installed SQL Server driver, enter the server and database details, select the appropriate authentication method, and save the DSN in a location accessible to the users who need it.
In the DSN setup wizard, use Test Data Source if available. Confirm that the test succeeds with the intended Windows or SQL Server account.
Hold Shift while opening the MDB file in Access to bypass startup forms and code, if the database allows the Shift bypass.
Open External Data > Linked Table Manager, select the SQL Server linked tables, and choose Always prompt for new location if the option is available. Select OK or Refresh, then choose the file DSN and confirm the authentication settings when prompted.
Restart Windows, open the MDB, and check whether the linked tables load without a login timeout or trusted-connection prompt.

Check network readiness after Windows startup
Use this check if the timeout occurs only on the first launch after a restart or continues after relinking.
Use WPS Office for everyday document and spreadsheet work
WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Microsoft Office formats, making it easier to move everyday documents and spreadsheets. It does not fix Access ODBC connections or replace an Access database front end.

Frequently Asked Questions
Why does the DSN test succeed when Access times out after startup?
The test may run after the network is ready, while Access may try to open linked tables earlier. Existing linked tables can also retain connection details that differ from the DSN settings. Check launch timing and refresh the links in External Data > Linked Table Manager.
How do I open the database without running its startup form?
Hold Shift while opening the MDB file in Access. This bypasses startup forms and code if the database's Shift bypass has not been disabled.
Do all workstations need the file DSN and ODBC driver?
Workstations that use the file DSN need access to its saved location and a compatible SQL Server ODBC driver. They also need network access and appropriate SQL Server permissions.
Can Windows authentication be used with the linked tables?
Yes, if SQL Server is configured to accept the user's Windows account and that account has the necessary permissions. Select Windows authentication when creating or selecting the DSN, and verify it when relinking the tables.




