Public Function ConnectAccess() As Boolean With cnnAccess ' Referme si déjà ouverte If .State <> adStateClosed Then .Close ' Paramétrage connexion .Mode = adModeShareDenyNone .ConnectionTimeout = 5 .Provider = "Microsoft.Jet.OLEDB.4.0" .Properties("Data Source").Value = sAccessFileName .Properties("Persist Security Info").Value = False If DBPassword <> "" Then .Properties("User ID").Value = DBUserId .Properties("Jet OLEDB:Database Password").Value = DBPassword End If ' Connexion On Error Resume Next .Open ' Attend connexion terminée Do While .State = adStateConnecting DoEvents Loop On Error GoTo 0 ' Au final, renvoie True si on est bien ouvert ConnectAccess CBool(.State adStateOpen) End With End Function