Recordset Not Updatable

[Eddy]

I have form that has a query as its control source. In trying to pull in
data from another table for the form I added the table to the query. With
the new table in the query I can no longer add data to the form. I get the
error "Recordset Not Updatable" Without the table in the query the
recordset is updatable, with it the recordset is not updatable.

Can anyone tell me where I can find out about this problem. Possible a
knowledge base article. To solve this problem and for future reference, I
would like to find out why the addition of the table makes the recordset
not updatable.

Thanks,

 

[John Mishefske]

I have form that has a query as its control source. In trying to pull in
data from another table for the form I added the table to the query.
With the new table in the query I can no longer add data to the form. I
get the error "Recordset Not Updatable" Without the table in the query
the recordset is updatable, with it the recordset is not updatable.

Can anyone tell me where I can find out about this problem. Possible a
knowledge base article. To solve this problem and for future reference,
I would like to find out why the addition of the table makes the
recordset not updatable.

Evidently the addition of that table prevents Jet from knowing which record
to update when a change is made. Calculated fields, UNION or GROUPing queries
and duplicate records can make a query not updateable.

The recordset has a Updateable property that you can check to find out.

Here is some reading material:
http://www.microsoft.com/technet/prodtechnol/sql/proddocs/msjet/jetch04.asp