Avoid re-entering SQL authentication password again and again

Public Sub Reconnect()
    Dim errs As Integer: errs = 0
    ReDim errTables(errs) As String
    
    Dim tables(4) As String
    tables(0) = "table1"
    tables(1) = "table2"
    tables(2) = "table3"
    tables(3) = "table4"
    
    Dim i As Integer
    For i = 0 To UBound(tables)
        Debug.Print "Linking " & tables(i)
        If Not AttachDSNLessTable(removeSchemaFromTable(tables(i)), tables(i), dbServer, dbName, dbLogin, dbPass) Then
            logTableInError errs, errTables(), tables(i)
        End If
    Next

    If errs > 0 Then
        Dim s As String
        s = ""
        For i = 0 To UBound(errTables)
            If Len(errTables(i)) > 0 Then
                s = s & errTables(i) & vbCrLf
            End If
        Next
        If Len(LTrim$(RTrim$(s))) > 0 Then
            MsgBox "Unable to link the following tables: " & vbCrLf & s
        End If
    Else
        MsgBox "All tables relinked"
    End If

End Sub
Private Function removeSchemaFromTable(tablename As String) As String
    Dim i As Integer
    i = InStr(tablename, ".")
    If i = 0 Then
        removeSchemaFromTable = tablename
    Else
        removeSchemaFromTable = Mid$(tablename, i + 1)
    End If
End Function
Private Sub logTableInError(ByRef errs As Integer, ByRef errTables() As String, ByVal tablename As String)
    ReDim Preserve errTables(errs)
    errTables(errs) = tablename
    errs = errs + 1
End Sub

'//Name     :   AttachDSNLessTable
'//Purpose  :   Create a linked table to SQL Server without using a DSN
'//Parameters
'//     stLocalTableName: Name of the table that you are creating in the current database
'//     stRemoteTableName: Name of the table that you are linking to on the SQL Server database
'//     stServer: Name of the SQL Server that you are linking to
'//     stDatabase: Name of the SQL Server database that you are linking to
'//     stUsername: Name of the SQL Server user who can connect to SQL Server, leave blank to use a Trusted Connection
'//     stPassword: SQL Server user password
'// https://support.microsoft.com/en-gb/help/892490/how-to-create-a-dsn-less-connection-to-sql-server-for-linked-tables-in
Function AttachDSNLessTable(stLocalTableName As String, stRemoteTableName As String, stServer As String, stDatabase As String, Optional stUsername As String, Optional stPassword As String) As Boolean
    On Error GoTo AttachDSNLessTable_Err
    Dim td As TableDef
    Dim stConnect As String
    
    For Each td In CurrentDb.TableDefs
        If td.Name = stLocalTableName Then
            CurrentDb.TableDefs.Delete stLocalTableName
        End If
    Next
      
    If Len(stUsername) = 0 Then
        '//Use trusted authentication if stUsername is not supplied.
        stConnect = "ODBC;DRIVER=SQL Server;SERVER=" & stServer & ";DATABASE=" & stDatabase & ";Trusted_Connection=Yes"
    Else
        '//WARNING: This will save the username and the password with the linked table information.
        stConnect = "ODBC;DRIVER=SQL Server;SERVER=" & stServer & ";DATABASE=" & stDatabase & ";UID=" & stUsername & ";PWD=" & stPassword
    End If
    Set td = CurrentDb.CreateTableDef(stLocalTableName, dbAttachSavePWD, stRemoteTableName, stConnect)
    CurrentDb.TableDefs.Append td
    AttachDSNLessTable = True
    Exit Function

AttachDSNLessTable_Err:
    
    AttachDSNLessTable = False
    'MsgBox "AttachDSNLessTable encountered an unexpected error: " & Err.Description

End Function
Public Function KeepConn()
'By having a form bound to a table we should be able to keep the connection open preventing timeouts
'But we don't want to see the form! Call this from autoexec
    On Error GoTo 0
    Form_KeepConnectionOpen.Visible = False
End Function