No Field Edit capability

  • Thread starter Thread starter WT
  • Start date Start date
W

WT

I have a large data file as the parent, left joined to a child table which is
many to one.
and the parent also joined to a sub query that counts the number of records
in the parent that match the child.

when I run the query it delivers all the data in a table but it will not
allow me to edit or change any of the records.
I have tried all the record locking options and also looked in the
Tool/options/Advanced tab for those settings and still I am unable to change
a field.

Help please.......
 
WT said:
I have a large data file as the parent, left joined to a child table which
is
many to one.
and the parent also joined to a sub query that counts the number of
records
in the parent that match the child.

when I run the query it delivers all the data in a table but it will not
allow me to edit or change any of the records.
I have tried all the record locking options and also looked in the
Tool/options/Advanced tab for those settings and still I am unable to
change
a field.
Click to expand...


Without seeing the actual SQL it's hard to be sure, but you've probably run
afoul of the fact that the Jet/ACE database engine considers any query that
includes grouping, or SQL aggregate functions like Count() and Sum(), to be
nonupdatable -- even when it doesn't logically have to be.

One workaround for this, albeit relatively inefficient, is to use a DCount()
expression in your query to get the record count, instead of Count().
 
Back
Top