hi! can anybody please help me with this problem. Currently i have the code below
StrSQL = "update users set username='" & UCase(txtUserChange.Text) & "',password='" & _
new_pswrd & "',admin_user='" & UCase(chkchange.Value) & "' where username='" & _
UCase(txtUserChange.Text) & "' and password='" & current_pswrd & "'"
MsgBox StrSQL, vbOKOnly
as you can see the code doesn't check if it updated my databses successfuly..i hope you have now idea what my problem is..my question is how will i check if it successfuly updated my databse or not. thanks in advance!!!