Hi, there.
Certainly not all queries are updateable. If you have SQL aggregate function, use a UNION or Crosstab query, DISTINCT predicate or a certain combinations of outer joins, then Access would be unable to resolve how to update query underlying tables.
Please post the SQL expression(s) and table(s) metadata.
Here is an example of how to post table MetaData :
Table Name=tblStudent - Field; Type; IndexInfo
-
StudentID; AutoNumber; PK
-
Family; String; FK
-
Name; String
-
University; String; FK
-
Mark; Numeric
-
LastAttendance; Date/Time
Regards,
Fish