modifying record in a vb.net form

[Signo.X]

Hello all,

I have a window form in vb.net that reads the data from an access database and displays it in text boxes..

when i try to modify a column in a record using the form,, then press save one the bindingNavigator , i get this msg :

cannot modify record because it has data related in other table.

but when i try to modify the exact same column/record directely using the Access database, it doesnt have any problem when i save it...

any idea why is that happening ?

~signo.X

 

[cjard]

Access has code embedded within to detect and cater for situations like this. Either perform the updates yourself separately via separate related datatables, separate db queries (table-less tableadapters), or through an updatable join view