Recordset not updatable message

  • Thread starter Thread starter LM
  • Start date Start date
L

LM

I am building a query that is made up of one (A)table and
(B)one query. Within the tabel their are to Yes/No
fields - when I change views and go to click on the box I
get the error message on the bottom left hand corner "The
Recordset is not updatable". If I delete Query B I can
then update the checkboxes.
Any suggestions would greatly help.
Thanks
 
To be more specific- I do have some data that appends to
table (A) and all fields that are from table A do not
allow for updates when the table is attached to query B.
Thanks Again.
 
This is caused when a query is using a linked table which
doesn't have a Unique Index or Primary Key in it's design.
Check the query portion of your update for a linked table
and look up Uniquetable Property in Help.
 
Back
Top