Update successful..?

[Kujen]

Hi all,

I have the following to uppdate a password:

StrQueryName = "QueryGeneric"
StrSql = "ALTER LOGIN " & Me.strUserId & " WITH PASSWORD ='" & Me.strNewPassword & "'"


With CurrentDb.QueryDefs(StrQueryName)
.SQL = StrSql
.ReturnsRecords = False
.Execute
.Close
End With

How can I check if the update was successful?
I would be nice to inform the user:
"Your password has changed"

Kent J.

 

[CaptainD]

A simple method would be to do a select statement to pull the password for the record you updated and compare it to "Me.strnewPassword"

If they match then it was updated.