RE: Hierarchial Update

Hi, again.
Today, I tried something else. I had come to suspect that my problems had
something to do with my operating on an Access database and not a SQL Server
database like the Northwind. In my Access database, I had defined relations
between the tables and enforced Referential Integrity. When I dropped this
requirement, my problems with Update disappeared. Now, this may not be the
proper thing to do, but at least it enabled me to continue. I would very
much appreciate a comment on this.

Regards,
Gudni

"Gudni G. Sigurdsson" wrote:

> 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
>