Dear All

This won't work

Code:
    cnn.BeginTrans
        sSQL = "INSERT INTO tblUsers " _
          & "(User_Name, Password, Group) VALUES ('" & txtUserName & "', '" & txtPassword & "', '" & cboGroup & "');"
        
        cnnMIS.Execute sSQL
    cnn.CommitTrans
This is what the sSQL string returns

INSERT INTO tblUsers (User_Name, Password, Group) VALUES ('Gary Lowe', 'newpass', 'Admins')

The only other field in the table is an ID field which is an auto number, will this have to be added to the sql string.

The database is access 97 FE = VB6