Update Access 2003 with DataGridView ADO.NET 2.0

[Niyazi]

Hi,

I have a form with DataGrid view and details and its working fine.
In the sepaerate button I want to update the database table columns. The
value comes from AS400 and inserted into string variable then my update works
and updates only DataGridView but not actual MS Access Database. Here is the
code:

Dim row As DataRow
For Each row In Me.DsKKAUTO.tbl_CREDIKOMAUTO.Rows
Dim mKKAUTO As String = ""
mKKAUTO = Trim(row(2))

Dim mTOK As String = ""
mTOK = Trim(row(9))

'SORT THE TEMP TABLE
Dim mEXPR1 As String = "(KKAUTO = '" & mKKAUTO & "') AND
(TOK = '" & mTOK & "')"
Dim mSORT1 As String = "KKAUTO ASC"

Dim tmpResultROWS As DataRow()
tmpResultROWS = Nothing
tmpResultROWS = dsAS400DOV.Tables(0).Select(mEXPR1,
mSORT1)

If tmpResultROWS.Length = 0 Then
'Do Nothing In Here
Else
If tmpResultROWS.Length = 1 Then
row.BeginEdit()
row.Item(11) = "True"
row.EndEdit()
Else
'Do Nothing In Here
End If
End If
Next

Me.DsKKAUTO.tbl_ CREDIKOMAUTO.AcceptChanges()

Me.Tbl_CREDIKOMAUTOTableAdapter.Update(Me.DsKKAUTO .tbl_CREDIKOMAUTO)
Does anyone knows why I can update my DataGridView and not the actual MS
Access 2003 Table?

Thank you very much for reading my post.

Rgds,
GC