View Single Post
  #1  
Old September 30th, 2004, 04:53 PM
Tina
external usenet poster
 
Posts: n/a
Default "Could not delete from specified table"

Can anyone help me. Im' trying to deleting records in a
table called "linkbase" where the "NUMBERS" field matches
the "Numbers" field in another table called Linked
Deletions 18-1.

My Sql Statement looks like this

DELETE Linkbase.*, Linkbase.NUMBER
FROM Linkbase, [Linked Deletions18-1]
WHERE (((Linkbase.NUMBER)=[Linked Deletions18-1].
[Number]));

I finally got the records I need to delete in Datasheet
view, however when I hit the Delete! button I get a
message "Could not delete from specified table". Any
ideas?