Read-only data

M

Mary

Hello Access Gurus
In a query that uses a query and a table that have two fields in a
one-to-one relationship, I result records, but cannot delete them in order to
update my master table. The message at the bottom left says Data is
Read-Only, but I can delete that result record directly from the table. Can
you tell me what I'm doing wrong? Thank you!
Mary
 
J

John Vinson

Hello Access Gurus
In a query that uses a query and a table that have two fields in a
one-to-one relationship, I result records, but cannot delete them in order to
update my master table. The message at the bottom left says Data is
Read-Only, but I can delete that result record directly from the table. Can
you tell me what I'm doing wrong? Thank you!
Mary
Click to expand...

One to one relationships are VERY rare, and you may not be using them
appropriately. It's not clear to me what you're updating or what
you're deleting!

That said... you must have a unique Index, such as a Primary Key, on
the join field in BOTH tables for the query to be updateable.

John W. Vinson[MVP]
 
Top