Syntax error in INSERT INTO statement.

[abedt]

I got the following error:
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.

The source error is : MYcmd.ExecuteNonQuery()

Here is my Code: (Help me.....Thanks)
'========================================
Function addTeacherRecord(ByVal lName As String, ByVal fName As String)




' Change Data Source to the location of Northwind.mdb on your local
Dim sConStr As String = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data " _
& "Source=" & Server.MapPath("~/App_Data/students.mdb")


Dim password As String = generatePassword()
Dim userStatus As String

If statusList.SelectedIndex = 0 Then
userStatus = "Yes"
Else
userStatus = "No"
End If

Dim userProfile As String

If profileList.SelectedIndex = 0 Then
userProfile = "User"
Else
userProfile = "Admin"
End If

Dim user_name = fName + lName(0)



Dim mySQL As String = "INSERT INTO teachersTable (FirstName, LastName, UserName, Password, UserStatus,active) VALUES ('" & fName & "','" & lName & "','" & user_name & "','" & password & "','" & userProfile & "','" & 1 & "')"


Dim MyConn As New Data.OleDb.OleDbConnection(sConStr)


MyConn.Open()
Dim MYcmd As New Data.OleDb.OleDbCommand(mySQL, MyConn)
MYcmd.ExecuteNonQuery()
MyConn.Close()


newsLable1.Visible = True
newsLable2.Visible = True
newsLable2.Text = "הזנת הנתונים עבור " & fName & " " & lName & " הסתיימה בהצלחה."
userPassword1.Visible = True
userPassword1.Visible = True
userPassword1.Text = password
UserName2.Text = fName + lName(0)


Return 0
End Function

[clain]

Dear..

this is a simple error...

Dim mySQL As String = "INSERT INTO teachersTable (FirstName, LastName, UserName, Password, UserStatus,active) VALUES ('" & fName & "','" & lName & "','" & user_name & "','" & password & "','" & userProfile & "','" & 1 & "')"

here is where you went wrong ..

you can change it to

Dim mySQL As String = "INSERT INTO teachersTable (FirstName, LastName, UserName, Password, UserStatus,active) VALUES ('" & fName & "','" & lName & "','" & user_name & "','" & password & "','" & userProfile & "',1)"

happy coding

[abedt]

Thanks for the help

I a new error, it's:
Expected query name after EXECUTE