Re: [GENERAL] Are updateable view as a linked table in ms-access a bad idea?[solved]

2006-12-14 Thread Richard Broersma Jr
I think I've solved my problem with connecting an update-able view as a linked table in MS Access. I invite all to comment on flaws or suggest improvements or other possible solutions. This is a test case that I am eventually going to use to model a document hierarchy. This test case is

[GENERAL] Are updateable view as a linked table in ms-access a bad idea?

2006-12-12 Thread Richard Broersma Jr
I expect what I am reporting is already a known problem, but since I haven't heard anyone else report it I thought I should at least mention it. I am also looking for suggestions from anyone about how they prefer to bind forms to multiple hierarchial tables in access. I tried to wrap them is

Re: [GENERAL] Are updateable view as a linked table in ms-access a bad idea?

2006-12-12 Thread Richard Broersma Jr
Please show us your exact view, table and rule definitions used by this example. -- update 0 is false I guess what you are seeing are partial updates of the view caused by a multi-action rule which doesn't see the updated tuple in its subsequent actions anymore. This