Could not delete from specified table

[Guest]

I have a delete query where by I am trying to delete records in one table
where similar records (an equals join) exist in another table.

When I preview the delete query it shows the records that should delete,
however when I actually run the query I get the messsage "Could not delete
from specified table".

There are no relationships between the two tables. Both tables only contain
two fields and are similar types (ie number, long integer and text).

 

[John Vinson]

I have a delete query where by I am trying to delete records in one table
where similar records (an equals join) exist in another table.

When I preview the delete query it shows the records that should delete,
however when I actually run the query I get the messsage "Could not delete
from specified table".

There are no relationships between the two tables. Both tables only contain
two fields and are similar types (ie number, long integer and text).

If there are no relationships, there are (probably) no indexes on the
joining fields. For a query to be updateable, you must have a unique
Index in the joining field in the "one" side table.

A Subquery might be a way around this; could you post the SQL of the
query?

John W. Vinson[MVP]