Delete records where joined fields are equal

[Jill]

I have 2 tables, both have a field that is the same. I
ran a select query to show me the records where the joined
field is equal. I would now like to delete the records;
however, when I run the delete query I get an error
message saying I don't have permission. I am the Admin
for the database, so this is definately not the case.

Thanks!

 

[John Vinson]

I have 2 tables, both have a field that is the same. I
ran a select query to show me the records where the joined
field is equal. I would now like to delete the records;
however, when I run the delete query I get an error
message saying I don't have permission. I am the Admin
for the database, so this is definately not the case.

Have you defined a Relationship between the two tables? The query will
not be updateable unless there is a unique index, such as a Primary
Key, on the joining field in the "one" side table.

Perhaps you could open the query in SQL view and post the SQL here,
and indicate from which table (or tables) you would like to delete
records.