N
Nick
Hello All,
i receive the message "Could not delete from specified
tables" when trying to run a delete query. The tables are
linked to sql server 2000. there are 2 joins in this
query. Table A contains the rows i want to delete from
and table B contains the records that are to be deleted
from table A. if i change this to a select, no problem.
the problem is when i change to a delete query. if i
preview the results of the delete query, it shows up
correctly. it's when i run the query, i get this
message.
i found an article in microsoft's KB to make sure that the
unique records property is set to yes. it did not make a
difference.
in sql 2000, both tables have an index, not unique however.
Thanks in Advance,
Nick
i receive the message "Could not delete from specified
tables" when trying to run a delete query. The tables are
linked to sql server 2000. there are 2 joins in this
query. Table A contains the rows i want to delete from
and table B contains the records that are to be deleted
from table A. if i change this to a select, no problem.
the problem is when i change to a delete query. if i
preview the results of the delete query, it shows up
correctly. it's when i run the query, i get this
message.
i found an article in microsoft's KB to make sure that the
unique records property is set to yes. it did not make a
difference.
in sql 2000, both tables have an index, not unique however.
Thanks in Advance,
Nick