Cannot update table via query

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have 2 tables...

Once they're joined (left outer join), I cannot update
data in the query datasheet (or linked form).

This is what I have done:
- In query design view, added the 2 tables
- Joined PKs of both tables by dragging
- Right-click on Join Properties and selected "Include
All from Tbl A and only those from Tbl B"

Again, why couldn't I update data in table A any longer?
If there's a way around this problem, how should I fix it?

Thanks,
Tom
 
Dear Tom:

It may be you will be able to perform the updates you want through this
query if you select "Dynaset (Inconsistent Updates)" For the Recordset Type
property of the query. Right click in the upper portion of the Query Design
Grid where the tables are shown, but not on one of the tables or the join
lines between the tables to get this list of "Query Properties."
 
Back
Top