Recordset is not updateable

message from =?Utf-8?B?TWFyayBQZXRyb3NraQ==?= on 3 Jun 2004

I am currently building a database. I used the wizards and they work well. However, I am unable to input data into the forms. I reviewed MS Access help feature and all settings are correct for editing data on a form: Record Locks - No Locks, Record set type - Dynset. The two tables in the query are one to one, linked by the last name.
I reviewed the topics in this discussion group with no success. Any other help would be appreciated.

John Vinson replied to =?Utf-8?B?TWFyayBQZXRyb3NraQ==?= on 03 Jun 2004

Last names are not unique - there are millions of people named Smith,
and even more named Wong. In order to be updateable, your tables must
be joined by a unique Primary Key. If you have two tables linked by
last name, then every record for Smith in the first table will be
linked to every record for Smith in the second, and you'll get
multiple repeats.

One to one relationships are VERY rare; if you're intentionally doing
Subclassing, you may be ok, but if you don't recognize the term you
may be on the wrong track. What are these two tables? Why would you
want a one to one relationship, rather than just including all the
fields in the same table?

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

=?Utf-8?B?SmFja2llIEw=?= replied to =?Utf-8?B?TWFyayBQZXRyb3NraQ==?= on 3 Jun 2004

Can you add or change data in your query itself? Also, is your query the record source on the form?

Archived message: Recordset is not updateable (Microsoft Access Forms)