check success of sql insert query

[Pouncer]

If (cn.State = adStateOpen) Then
                    Dim Str As String
                    Str = "INSERT INTO " & SQLTable & "(Username, Password) VALUES(" & Text1.Text & "," & Text2.Text & ")"
                    adoRS.Open str, cn 
                End If

how can i tell if the insert was successful?
and does the inset syntax look correct to you guys? i havent tested it yet

edit**********
tested it and it throws an 'sql sntax' error