Originally Posted by
JoeM
It might be helpful if you post the SQL code of your query too.
Certain query types, like Aggregate Queries and Union queries are not updateable.
So, here's SQL:
Code:
SELECT tbl_act.ContName, tbl_Cont.ContTmpID, tbl_Cont.EntryVal, tbl_Cont.ContEntry, tbl_Sub.ID AS BC_ID, tbl_act_1.ID AS CauseID, tbl_act_1.ContName AS CauseName, tbl_act.ID
FROM ((tbl_Cont INNER JOIN tbl_act ON tbl_Cont.ContID = tbl_act.ID) INNER JOIN tbl_act AS tbl_act_1 ON tbl_act.Cause = tbl_act_1.ID) INNER JOIN tbl_Sub ON tbl_act_1.Cause = tbl_Sub.ID
WHERE (((tbl_Cont.ContTmpID)=120) AND ((tbl_Cont.ContEntry)='Value') AND ((tbl_Sub.ID)=2));
As you see, there are quite some tbls involved.
@june:
Is it thus like i can edit the fields if i only pick fields from ONE tbl here ? Or, the other way round:
Is it impossible to edit (update) (some) fields because they are not taken from the same table ?
I tried an example with SELECTing only from one tbl, like this :
Code:
SELECT tbl_Cont.ContTmpID, tbl_Cont.EntryVal, tbl_Cont.ContEntry
FROM ((tbl_Cont INNER JOIN tbl_act ON tbl_Cont.ContID = tbl_act.ID) INNER JOIN tbl_act AS tbl_act_1 ON tbl_act.Cause = tbl_act_1.ID) INNER JOIN tbl_Sub ON tbl_act_1.Cause = tbl_Sub.ID
WHERE (((tbl_Cont.ContTmpID)=120) AND ((tbl_Cont.ContEntry)='Value') AND ((tbl_Sub.ID)=2));
.... but it does not work as well.
By the way, as stated before, i can neither edit the fields without using the form, by trying to edit smth. in the query (table view), so it is not an issue of binding controls and of locked controls and so on ... well, maybe that may come later as well. For now, it seems my query is not "UPDATEABLE" (that is the term of my access-message), and i don't know why.
But thanks to your help, i have an idea by now, what the reason might be, so thanks a lot so far.
Best regards,
...
field in query "not editable" ...
Windows 7 64bit 
Access 2010 64bit
Reply With Quote
