Locked Fields?

[Guest]

I've created a query using two tables within the same database and now when I
run the query I can't edit any fields. I've looked at everything I can think
of and can't figure out what's going on.

Any help or ideas would be appreciated.

Thanks,

Kevin

p.s. I have searched through the previous posts and couldn't find any
similar problems..

 

[Allen Browne]

The query results will be read-only if any of the following apply:
.. 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.)

 

[Guest]

Thank you!! I do have a COUNT in the select. I'll do a little workaround and
get it going. Thanks for your help.

Kevin