If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
delete table content | kayak | Using Forms | 1 | August 17th, 2004 01:05 PM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |