recordset not updateable

[Kathy R.]

Using MSAccess 2000
I have a database that is several years old and has been working up
until a few weeks ago. A query that used to work and was updateable now
gives me the message "Recordset not updateable" whenever I try to change
information in it, either via a form based on the query or directly in
the query itself.

Any help in tracking down this problem and how to fix it would be very
much appreciated!

Kathy

The query is based on two tables, joined on the FamID field in the query
design grid (Only include rows where the joined fields from both tables
are equal)

Family_tbl
FamID (key field, autonumber)
LastName (text)
several other fields

Individual_tbl
IndID (key field, autonumber)
FamID (number)
FirstName (text)
several other fields

* I can open both tables and change information in them

* I can create a new query with EITHER the Family_tbl or the
Individual_tbl in it and change information there

* But as soon as I put both tables into the query I cannot change the
information in the fields

* I have tried exporting just the tables and query (definitions only)
into a brand new database and I get the same results

* If I create a new tables and a query based on them (in the old
database) that are identical to the ones that aren't working, I can
change the information in them

 

[Beetle]

See if this link helps resolve anything;

http://allenbrowne.com/ser-61.html

 

[Kathy R.]

Thank you, thank you, thank you!!! Somehow the index property of the
primary key on the family_tbl was changed to "Yes (duplicates OK)"

Thank you for pointing me in the right direction.

Kathy