Delete Query

  • Thread starter Thread starter GeoDude
  • Start date Start date
G

GeoDude

I need help in designing a delete query.

I have two tables and I need to join three fields. When I run the
delete query it says "cannot delete from specified tables". I have
successfully deleted when I only join one field. Is there a way to
delete data from a table with a query and three fields joined?

Thanks in advance.
 
GeoDude said:
I need help in designing a delete query.

I have two tables and I need to join three fields. When I run the
delete query it says "cannot delete from specified tables". I have
successfully deleted when I only join one field. Is there a way to
delete data from a table with a query and three fields joined?

Thanks in advance.
Click to expand...

Please post the SQL of the query.
 
I need help in designing a delete query.

I have two tables and I need to join three fields. When I run the
delete query it says "cannot delete from specified tables". I have
successfully deleted when I only join one field. Is there a way to
delete data from a table with a query and three fields joined?

Thanks in advance.
Click to expand...

Yes... but not all queries are updateable, and unless the query is
updateable it will in fact give this message.

You will need a unique Key, such as a Primary Key, on the combination
of the three fields.

Perhaps you could open the query in SQL view and post the SQL text
here; someone may be able to suggest an alternative query that will
work.

John W. Vinson[MVP]
 
Back
Top