Cannot Update Data in Query

  • Thread starter Thread starter Chaplain Doug
  • Start date Start date
C

Chaplain Doug

I have a form whose data source is an "Inner Join" query.
I cannot update any of the fields when using the query
(even when trying directly by opening the query). Is this
an inherent property of such a query (i.e., cannot update
fields)?
 
Actually the problem arises when I draw data from three
tables in the query. This involves two inner joins. Just
one inner join does not cause the problem.

Table Grades is linked to table Lessons by LessonID and to
table Units by UnitID. Table Lessons is linked to table
units by UnitID.
 
Doug,
If you join 3 or more tables in a query, a non updateable recordset is
created. You can find more information if you search "updatable" in
Access's help.

Lori
 
I have a form whose data source is an "Inner Join" query.
I cannot update any of the fields when using the query
(even when trying directly by opening the query). Is this
an inherent property of such a query (i.e., cannot update
fields)?
Click to expand...

Many queries are updateable, and many aren't. A simple two-table join
will usually be updateable provided there is a unique Index on the
joining field on the "one" side table and a defined relationship.

Perhaps you could post the SQL of the query (as is generally suggested
when posting questions about specific queries).
 
Well, the link from Grades to Lessons sounds OK, and the link from Grades to
Units is OK, too. It's the link from Lessons to Units that makes the query
not updatable. What is the actual structure of your tables? Why is Lessons
related to both Grades AND Units?

Without knowing all the details, it sounds like your relatinships are:

Lessons 1->M Grades M<-1 Units

If that's the case, then you should be able to edit the Grades data in a
query that links all three tables (sans the link from lessons to units).

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Thank you. There was an unnecessary link and when it was
removed the confusion (ambiguity or whatever) was removed
and all worked well. Thanks for the help!
 
Back
Top