i dont know how to update the data into access with vb 6.0

First thing: check your data.
Because you don't list the columns you are trying to INSERT into, Access assumes that you want to insert data starting from the first column - so if you have an automatic ID column at the beginning - and it's very common - the INSERT will fail, because you aren't allowed to write to them. So look at your table definition, check the data in the table, and make sure that at least one row matches the id value you are trying to UPDATE later.
ANd then change your query to list the columns:

INSERT INTO Payment (columnName1, columnName2, columnName3, columnName4) VALUES (...

Second - and this is really important - don't do it like that! Do not concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead.
See here: http://www.vbforums.com/showthread.php?552665-Database-How-do-I-use-an-ADO-Command-object[^]

If that doesn't fix it, we need to know the exact error message, and the line that it appears on.

You have to use ADODB.Command[^] together with Execute[^] method to update your data.

For further details, please see:
Using ADO with Microsoft Visual Basic[^]
ADO Code Examples in Visual Basic[^]
How to Reference ADO 2.0 in Visual Basic[^]

it's good to have you..
i need to update no insert..
can you help me with that???

con.Close
    con.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = C:\Users\Public\Documents\SAMPLE.mdb"
    If con.State = adStateOpen Then
    con.Close
    End If
    con.Open
    rec.Open "select * from Payment1", con, adOpenStatic
    While rec.BOF = False
    If rec.State = adStateOpen Then
    rec.Close
    End If
    rec.Open "update Payment1 set amountPaybal='" & txtTa.Text & "',paidAmount='" & Text4.Text & "',date='" & Label11.Caption & "' where id=" & Combo1.Text & "", con, adOpenStatic
    MsgBox "successfully inserted"
    Wend

this is what i have on update button
but it's not working