delete data

[JIM.H.]

Hello,
I have two table: table1 and Table2, I want to delete all
the items common in table2. Table2 is a link table from
another access db file. I add table1 & table2 and link
them by with a field available in both. I change the query
to be a delete query and add tabel2.* as a field. Now when
I run query it says, 'can not delete from specified
tables'. I am able to delete when I open and delete any
record in any table.
What is problem?
Thanks,
Jim

 

[Van T. Dinh]

You probably need to use the DISTINCTROW keyword.

See the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=240098

HTH
Van T. Dinh
MVP (Access)