Hierarchial Update

Hierarchial Update

am 31.03.2008 13:30:01 von GudniGSigurdsson

Hi.
I have recently started using VS2008 after having used VS2005 in the past.
I have problems with updating related tables in an Access database
(Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=F:\Fjarskiptabunadur\FjarskiptaBunadur.mdb). I have 2 tables:
Producers and Units, the former being the parent the latter the child table.
When I change e.g. the name of a producer (not a key column in that table)
and try to save the changes, I get a message like The record cannot be
deleted or changed because table 'Units' includes related records.
I have worked through the HierarchialUpdateWalkthrough
example with the Northwind database (tables Customers and Orders) and that
works as expected. In my own example, I think I am doing everything in the
same way as in the Northwind example with tableAdapterManager and everything.
The only difference is that the Northwind example works and mine doesn´t.

I have tried to solve this for some time now and would be very gtateful for
some comment.

Regards,
Gudni