simple Delete Query not working, (Error 3086)

[rina]

I've made dozens of Delete queries, and suddenly I can't
get this to work. When I run it, I get a message box that
says "Could not delete from specified tables." When I go to
the Help for it, is adds "(Error 3086)", and says my tables
are marked "Read-Only" and I have to change them. I am the
sole owner and creator of this Db, so it's not a security
issue. Nothing is tagged as Read-Only. It's all very
straighforward. And I can't find this problem anywhere in
the MS Knowledge Base.

I have two tables, with a one-to-one relationship based on
one numerical ID field. I have them both in the query. I'm
trying to delete the fields in table A where the ID field
matches table B.

I've tried many combinations: no Join; Inner, Left and
Right Joins; pulling the ID field down to the grid with
different syntax to make them match ("=", "Like", nothing);
even just entering an ID number by hand. As long as that
second table is in the query, it won't delete. I even tried
replacing it with another table just as a test, and that
didn't work either.

The View Results displays exactly the records I want
deleted, so I know the link is working and the records are
there.

But the only way this works is if table A is the only table
in the query, but that defeats my purpose.

I know I've made this kind of thing work before. It can't
be that difficult. What am I doing wrong?

Thanks in advance to anyone who can help with this.

 

[rina]

For now, I guess this will work: Query Properties, "Unique
Records" = Yes. I'm not sure what will happen if the
records are not unique, but I'm over this hurdle for now.

 

[John W. Vinson]

What am I doing wrong?

Probably you do not have a unique Index on the joining field. Could
you post the SQL view of the query?