I have problem with inserting values in database.
I got error at line myCommand.ExecuteNonQuery().That error is Oledb Exception.What are the possibilities of this error.

At least let us know what is the error message in thrown exception

There are about 2132231321 possiblities as to what that error could be caused from; try not to be so vauge. What is the error message, can we see some code, etc.

"The one language all programmers understand is profanity."

I have databse Crime.mdb at location d:\Ty256\Police-Crime\Crime.mdb.I have table named LogIn which has two fields UserId and Password.I want to create new record in this table by using Insert Query.This values are collected from two text boxes txt1(user name) & txt2(password) and insert them into LogIn table.This should be done on click of Add button.Connection should be opened and closed on click of Add.

Dont double post.

INSERT INTO login(userID, password) VALUES('" & txt1.text & "','" & txt2.text &"')"

"The one language all programmers understand is profanity."

I have following code that gives me error at this line
"myCommand.ExecuteNonQuer()".The error is Oledb Exception.What is wrong with this code.Give me right code.

Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\TYBSC\Police-Crime\Crime.mdb"
    Dim myAdapter As New OleDbDataAdapter
    Dim myDataSet As New DataSet
    Dim myConnection As OleDbConnection
    Dim myCommand As OleDbCommand
    Dim myDataView As New DataView

    Private Sub frmAdmin_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        myConnection = New OleDbConnection(strConnection)
    End Sub

    Private Sub cmdAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdAdd.Click
        myCommand = New OleDbCommand("INSERT INTO login(userID, password) VALUES('" & txtUserName.Text & "','" & txtPassword.Text & "')")
        myCommand.Connection = myConnection
        myConnection.Open()
        myCommand.ExecuteNonQuery()
        myConnection.Close()
    End Sub

What is the error message?

"The one language all programmers understand is profanity."

This is error message

"An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll"

What line, what was the stack trace, etc etc etc??

"The one language all programmers understand is profanity."

This is my code

Private Sub cmdAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdAdd.Click
        myCommand = New OleDbCommand

        myCommand.Connection = myConnection
        Dim intPositin As Int16
        intPositin = myCurrencyManager.Position

        myCommand.CommandText = "insert into login (UserId, Password) values (@UserId, @Password)"
        myCommand.Parameters.Add("@UserId", txtUserName.Text)
        myCommand.Parameters.Add("@Password", txtPassword.Text)
        myConnection.Open()
        Try
            myCommand.ExecuteNonQuery()
        Catch ex As Exception
            MessageBox.Show(ex.ToString)
        End Try
        myConnection.Close()
        FillDataSetAndView()
        BindFields()
        myCurrencyManager.Position = myCurrencyManager.Count
        ShowPosition()
        StatusBar1.Text = "Record Added"
        Clear()
    End Sub

I am using Try...Catch to catch exception.
I get Following exception

Syntax error in INSERT INTO statement

What is wrong with code.
if you have another code for inserting above values give me that code