1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
| Sub Changer_MDP_BDD()
Dim sBDD As String, sMDP As String, sMDPnouveau As String
sBDD = "C:\test\LaBase.mdb"
sMDP = "abc" ' Mot de passe actuel
sMDPnouveau = "" ' Nouveau mot de passe vide souhaité
ChgAccDbPwd sBDD, sMDP, sMDPnouveau
End Sub
Sub ChgAccDbPwd(strDB As String, oldPWD As String, NewPWD As String)
Dim db As DAO.Database
Dim bCanRetry As Boolean
On Error GoTo Errh
bCanRetry = True
If oldPWD <> "" Then
Set db = DBEngine(0).OpenDatabase(strDB, True, False, ";pwd=" & oldPWD)
Else
Set db = DBEngine(0).OpenDatabase(strDB, True)
End If
If Not db Is Nothing Then
db.NewPassword oldPWD, NewPWD
db.Close
End If
Sortie:
Set db = Nothing
Exit Sub
Errh:
If bCanRetry Then
If MsgBox("Erreur No." & Err.Number & " : " & Err.Description, _
vbRetryCancel + vbQuestion + vbDefaultButton1, "Erreur") = vbRetry Then
Resume
Else
bCanRetry = False
Resume Next
End If
End If
MsgBox "Erreur No." & Err.Number & " : " & Err.Description, vbExclamation, "Erreur"
Resume Sortie
End Sub |
Partager