Problem to save Child table data

See more:

VB

MS-Access

Hello,

I'm trying to save the MS Access Child data from Form1. Child table is consisting of Child table datagrid where I am picking the Parent column data.

No errors are generated - but the Access Database will not be updated!

The Form code is as follows:

Public Class Form1
    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        ' Load parent before child
        Me.ParentTableAdapter.Fill(Me.TestiDBDataSet.Parent)
        Me.ChildTableAdapter.Fill(Me.TestiDBDataSet.Child)
    End Sub

    Private Sub ChildBindingNavigatorSaveItem_Click(sender As Object, e As EventArgs) Handles ChildBindingNavigatorSaveItem.Click
        Try
            Me.Validate()
            ' Call EndEdit for all BindingSources
            Me.ParentBindingSource.EndEdit()
            Me.ChildBindingSource.EndEdit()
            Me.TableAdapterManager.UpdateAll(TestiDBDataSet)
            MsgBox("Data updated")
        Catch ex As Exception
            MsgBox("Data update failed")
        End Try
    End Sub

    Private Sub ChildDataGridView_enter() Handles ChildDataGridView.Enter
        ' You must commint the parent row to the datatable before adding child rows
        Me.ParentBindingSource.EndEdit()
    End Sub

End Class

PS. I also have set the Child and Parent data relation constraint for "Both relation and Foreign key" option.

PS. I also have debugged that during the build the TestiDBDataSet will be updated correctly.

After all this the MS Access Database is not updating but there's generated MS Access Record Locking information at correct time label.

What's wrong?? Any information appreciated...