Cannot edit a field in a query

[maupiti]

Access 2003

I have a query that are nested four level deeps.
In each of the query properties the "Recordset Type:"
In the Query Property is set to: Dynaset (Inconsistent Updates).

When I created two very simple table, and run a single query
with the "Recordset Type:" Dynaset (Inconsistent Updates),
I can edit the field.

///////////////////////////////////////////

After the query is run, I tried to edit a field, but
it won 't let me.

Query_4
Query_3
Query_2
Query_1

 

[Golom]

The usual cause of this is that your query is a non-updatable query. dbInconsistant just allows you to edit fields that violate the join condition(s) of the query. It is however necessary that the query be structured such that a unique record and field in every base table involved can be identified. If it cannot then Access can't determine which fields to update and the query becomes non-updatable.

Queries that involve outer joins, cross-joins, computed fields and grouping are usually not updatable. Similarly, queries that do not include primary key fields are usually not updatable.

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886