Query Data Cannot Be Updated?

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!
 
J

John Vinson

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.

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?
 
J

Jeff

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!
 
J

John Vinson

I will continue to try using a subform, but can't seem to accurately
link the main form and subform just yet.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top