"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?
|