Recordset Not Updatable

[TC]

Make sure your query uses JOIN clauses, not just commas, to join the tables.

For example, this could be updatable:

SELECT ..
FROM T1 INNER JOIN T2
WHERE ...

but this definitely *will not* be updatable:

SELECT ...
FROM T1, T2
WHERE ...

There is more information on updatable queries in online help.

HTH,
TC

 

[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,

 

[Ken Snell]

In order to use a query to update a table's data, the query must be an
"updateable query". This term means that the query must be able to uniquely
identify each record in the tables so that it knows which record's value(s)
are to be changed.

The reasons for why a query may be nonupdateable are varied and sometimes
not obvious. See these links for more info (watch for word- and
line-wrapping; all URLs are one line):

"When can I update data from a query?"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/htm
l/acconDeterminingWhenCanUpdateDataQueryS.asp


"Harnessing the Power of Updatable Queries"
http://msdn.microsoft.com/library/default.asp?url=/archive/en-us/dnaraccgen/
html/msdn_harness.asp