Query Data Cannot Be Updated?

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I am linking two tables and a query into a "NewQuery" for use in a
form. Table1 includes records for all athletic events with a field
for season (there are several games/records per season), Table2
contains information for each season (linked/relationship to Table1),
and Query1 is a query created from a crosstab query which totals the
team's record for the season (a running count of wins and losses). As
the scores are entered on Table1, the crosstab query updates the
record and hence Query1.

When I open "NewQuery," I can view all the data from Table1, Table2,
and Query1. I cannot, however, update data in "NewQuery;" when I
attempt to update any data, I receive an error message indicating that
"This recordset is not updateable." I can understand that the data
from Query1 is not updateable, since it is derived from a crosstab
query, but am not sure why the data within the new query that is from
Table1 and Table2 cannot be updated.

Any thoughts? Have I created a circular query/reference or committed
some other Access faux pas? Thanks in advance!
 
When I open "NewQuery," I can view all the data from Table1, Table2,
and Query1. I cannot, however, update data in "NewQuery;" when I
attempt to update any data, I receive an error message indicating that
"This recordset is not updateable." I can understand that the data
from Query1 is not updateable, since it is derived from a crosstab
query, but am not sure why the data within the new query that is from
Table1 and Table2 cannot be updated.
Click to expand...

If NewQuery contains or references the crosstab query at all, it won't
be updateable; no query containing a Totals query ever is. Could you
post the SQL?
 
Thanks, John and Duane; that answers my question. The reason that I
cannot update the data is that a portion of the data in the subject
query are derived from a crosstab query.

What I had hoped to do was to use "NewQuery" for a form on which I
could update all data except those data derived from the crosstab
query, which I merely wanted to display for reference on the form. I
will continue to try using a subform, but can't seem to accurately
link the main form and subform just yet.

Thanks again for your responses!
 
I will continue to try using a subform, but can't seem to accurately
link the main form and subform just yet.
Click to expand...

That should solve the problem. How are the tables related to the
Query, logically? What would you use as the Recordsource for the
mainform?
 
Back
Top