Access eliminates the need for DSN files to quickly connect to SQL Server

1th step. Import required link tables in SQL Server via ODBC

Step 2nd. Add in the load code of the startup form

This code:

Private Sub Form_Load ()
On Error GoTo AE
DoCmd.TransferDatabase aclink, "ODBC", "Odbc;driver=sql Server;" Server=server\yde; Uid=sa; Pwd=a123;database=daad ", actable," "," ", True
Ae:
Exit Function
End Sub

Description
"Server\yde" for SQL Server
SA SQL connection user name
A123 SQL connection Password
The database to be linked by DAAD

To ensure that no error messages occur, add the code that handles the error.