SQL Insert Syntax Error

[NewsBot]

******* Dim queryString As String = "INSERT INTO users(email, first_name, last_name, password, phone_number, group) VALUES('" & Me.txtEmail.Text & "','" & Me.txtFirstName.Text & "','" & Me.txtLastName.Text & "','" & Me.txtPassword.Text & "','" & Me.txtPhoneNumber.Text & "','members');"

 

 

Should be working? I am having to give it the column names because the column before email is a pk and is an auto-number data type.

 

I just placed a breakpoint on the line so I could see the formatted string and all looks well.

 

Any advice?

 

Thanks.

 

 

More...

 

View All Our Microsft Related Feeds