to update using datatable,datas et,data adapter

[riyap]

Hi
i have a question regarding a update in msaccess DB using string builder,DATA SET AND DATA RELATIONS
can we do that in access DB
i have a table in access i need to pass more than 1 record and get o/p value and update in table again
so for this i used :
i have 2 datatables which i loaded with select command n records in
dlog1 ,dlog2
so im passing log 1 values into oracle stored procedure ,i got the values and im loading it in log3 data table
so now i want to update dlog3 into DB by comparing the Datarow and datacolumn with dlog2
and update in access
i wrote code here but its goin into deadlock condition and not update the values

   Private Sub updlog()
        Dim dsRel As New DataSet
        dsRel.Tables.Add(dlog2)
        dsRel.Tables.Add(dlog3)
        dsRel.Relations.Add("upd1", dsRel.Tables("dlog2").Columns("id"), dsRel.Tables("dlog3").Columns("id"))
        Dim drRel As DataRow
        Try
            Dim sb As New StringBuilder
            For Each dr As DataRow In dsRel.Tables("updlog3").Rows
                For Each dc As DataColumn In dsRel.Tables("updlog3").Columns
                    If dc.Equals("id") Then
                        drRel = dr.GetParentRow("upd1")
                        sb.Append(drRel.Item("status").ToString() & ",")
                        sb.Append(drRel.Item("message").ToString() & ",")
                    Else
                        sb.Append(dr(dc).ToString() & ",")
                    End If
                Next
                sb.Remove(sb.Length - 1, 1)
                sb.Append(vbCrLf)
            Next
 
        Catch ex As Exception
            MessageBox.Show(ex.ToString)
            Throw New Exception(ex.ToString)
        Finally
 
        End Try
    End Sub
End Class
 

sb.append means is it updateing the record