1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| Public Function ConnectionBase()
Dim conn As New ADODB.Connection
On Error GoTo ErrCo
conn.Open "FILE NAME=" & CurrentProject.Path & "\Connection.UDL"
If conn.State = adStateClosed Then
conn.Close
Set conn = Nothing
GoTo ErrCo
End If
conn.CommandTimeout = 240
If InStr(1, conn.ConnectionString, "Integrated Security=SSPI", vbTextCompare) > 0 Then 'Secu NT
CurrentProject.OpenConnection conn.ConnectionString
ElseIf conn.Properties("Password") = "" Then
CurrentProject.OpenConnection conn.ConnectionString, conn.Properties("USER ID"), conn.Properties("Password")
Else
CurrentProject.OpenConnection conn.ConnectionString, conn.Properties("USER ID")
End If
Exit Function
ErrCo:
MsgBox "Impossible de se connecter" & vbCrLf & "L'application va se terminer" & vbCrLf & "Vérifiez le fichier '" & CurrentProject.Path & "\Connection.udl'", vbOKOnly + vbExclamation, "Fermeture"
Application.Quit
End Function |
Partager