What determents is recrordset updatable or not?

[Domac]

Query based on sums etc. (Aggregate) is not updatable , but what determents
is query updatable or not!

I have query that uses GroupBy query to retreive MaxDate from table so I can
position myself at that row and edit or AddNew to that result!

Please help me!

Domac!

 

[Allen Browne]

Any query that aggregates records will be read only, since there is no ONE
record that you can type into. You will not be able to edit or append
records to a GROUP BY query.

Here's a list of some other things that will make your query read-only:
.. It has a GROUP BY clause (totals query).
.. It has a TRANSFORM clause (crosstab query).
.. It contains a DISTINCT predicate.
.. It uses First(), Sum(), Max(), Count(), etc. in the SELECT clause
(performs aggregation).
.. It involves a UNION.
.. It has a subquery in the SELECT clause.
.. It uses JOINs of different directions on multiple tables in the FROM
clause.
.. The query's Recordset Type property is set to Snapshot.
.. The query is based on another query that is read-only (stacked query.)
.. Your permissions are read-only (Access security.)
.. The database is opened read-only, or the file attributes are read-only, or
the database is on read-only media (e.g. CD-ROM, network drive without write
privileges.)

 

[Domac]

Thanks a lot!

This problem has bothered me for some time !!
Now i finally have a list of reasons!