Access recordset not updateable
Posted on 2016-11-17
OK, this is strange (A2007)
I have a form which has a recordsource of query (qry_frm_Families). I define the SQL of this query at runtime based upon several criteria entered on menu form, but the SQL of this query looks like either:
SELECT * FROM qryFamiliesSelected <= this one has a couple of field criteria
SELECT * FROM qryFamiliesSelectedAC <= this one has some additional criteria
For some reason, this form/query indicatwa that the Recordset is not updateable. However, if I simply open either qryFamiliesSelected or qryFamiliesSelectedAC, or set the RecordSource of the form to either of the queries mentioned above, the form/recordset is updateable.
There are no aggregations, DISTINCT, DISTINCTROW, or anything in this query. I even went so far as to explicitly enumerate all of the fields instead of using the * in the SELECT statement.
To be fair, the BE for this database is SQL Server, and the tables used in these queries are all linked tables. But I cannot figure out why the source queries are editable, but a query based upon them, where all fields are selected and no additional criteria are defined is not.