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? |
#2
|
|||
|
|||
You need to put the "joined" table into a subquery so that only one table is
in the main SQL statement: DELETE Linkbase.* FROM Linkbase WHERE Linkbase.NUMBER IN (SELECT [Linked Deletions18-1].[Number] FROM [Linked Deletions18-1]); -- Ken Snell MS ACCESS MVP "Tina" wrote in message ... 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? |
#3
|
|||
|
|||
Ken,
Thanks for your help! I tried your suggestion and I am still getting the same error msg. Do I have some kind of block on the "linkbase" table that I am unaware of ???? Tina -----Original Message----- You need to put the "joined" table into a subquery so that only one table is in the main SQL statement: DELETE Linkbase.* FROM Linkbase WHERE Linkbase.NUMBER IN (SELECT [Linked Deletions18-1].[Number] FROM [Linked Deletions18-1]); -- Ken Snell MS ACCESS MVP "Tina" wrote in message ... 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? . |
#4
|
|||
|
|||
Tina,
Is the table Local (local means that is not a linked table to another database)? If not, try to put the bracket around the Linkbase.NUMBER. Also make sure the table Linkbase has the field "NUMBER" in there (Access is Case sensitive). I hope this helps. Like this: ======================================= DELETE Linkbase.* FROM Linkbase WHERE [Linkbase].[NUMBER] IN (SELECT [Linked Deletions18-1].[Number] FROM [Linked Deletions18-1]); ======================================== -----Original Message----- Ken, Thanks for your help! I tried your suggestion and I am still getting the same error msg. Do I have some kind of block on the "linkbase" table that I am unaware of ???? Tina -----Original Message----- You need to put the "joined" table into a subquery so that only one table is in the main SQL statement: DELETE Linkbase.* FROM Linkbase WHERE Linkbase.NUMBER IN (SELECT [Linked Deletions18-1].[Number] FROM [Linked Deletions18-1]); -- Ken Snell MS ACCESS MVP "Tina" wrote in message ... 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? . . |
#5
|
|||
|
|||
I'm sorry to be a pain in the hmhm. I tried your
suggestions. It is still not working. I double checked both tables, names, field names etc.. for case sensitivity. I am able to see the records that art to be deleted in datasheet view, so I know they are being located with the query. But, for whatever reason, once I hit "Delete" I keep getting the "Could not delete blah blah blah". As far as I know, Linkbase is not linked to any other tables. It does have a different Icon in front of the name, it has a little flipped open notebook where the other tables all have the little data sheet. I don't have a clue why! Anyway anything else you can think of would be greatlty appreciated! Tina -----Original Message----- Tina, Is the table Local (local means that is not a linked table to another database)? If not, try to put the bracket around the Linkbase.NUMBER. Also make sure the table Linkbase has the field "NUMBER" in there (Access is Case sensitive). I hope this helps. Like this: ======================================= DELETE Linkbase.* FROM Linkbase WHERE [Linkbase].[NUMBER] IN (SELECT [Linked Deletions18-1].[Number] FROM [Linked Deletions18-1]); ======================================== -----Original Message----- Ken, Thanks for your help! I tried your suggestion and I am still getting the same error msg. Do I have some kind of block on the "linkbase" table that I am unaware of ???? Tina -----Original Message----- You need to put the "joined" table into a subquery so that only one table is in the main SQL statement: DELETE Linkbase.* FROM Linkbase WHERE Linkbase.NUMBER IN (SELECT [Linked Deletions18-1].[Number] FROM [Linked Deletions18-1]); -- Ken Snell MS ACCESS MVP "Tina" wrote in message .. . 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? . . . |
#6
|
|||
|
|||
Tina,
I have try a sample of my own data using the query that I suggested. Of course, both table are local to this access program. There is no problem with the query. My next guess is that the table Linkbase is not local to your access program. It is an link table or things. The usually to delete from a link table you have to have an primary key defined in that link table. If that table is not linked or has a primary key, then I am out of ideas. I hope this help. -----Original Message----- I'm sorry to be a pain in the hmhm. I tried your suggestions. It is still not working. I double checked both tables, names, field names etc.. for case sensitivity. I am able to see the records that art to be deleted in datasheet view, so I know they are being located with the query. But, for whatever reason, once I hit "Delete" I keep getting the "Could not delete blah blah blah". As far as I know, Linkbase is not linked to any other tables. It does have a different Icon in front of the name, it has a little flipped open notebook where the other tables all have the little data sheet. I don't have a clue why! Anyway anything else you can think of would be greatlty appreciated! Tina -----Original Message----- Tina, Is the table Local (local means that is not a linked table to another database)? If not, try to put the bracket around the Linkbase.NUMBER. Also make sure the table Linkbase has the field "NUMBER" in there (Access is Case sensitive). I hope this helps. Like this: ======================================= DELETE Linkbase.* FROM Linkbase WHERE [Linkbase].[NUMBER] IN (SELECT [Linked Deletions18-1].[Number] FROM [Linked Deletions18-1]); ======================================== -----Original Message----- Ken, Thanks for your help! I tried your suggestion and I am still getting the same error msg. Do I have some kind of block on the "linkbase" table that I am unaware of ???? Tina -----Original Message----- You need to put the "joined" table into a subquery so that only one table is in the main SQL statement: DELETE Linkbase.* FROM Linkbase WHERE Linkbase.NUMBER IN (SELECT [Linked Deletions18-1].[Number] FROM [Linked Deletions18-1]); -- Ken Snell MS ACCESS MVP "Tina" wrote in message . .. 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? . . . . |
#7
|
|||
|
|||
Aha, you're trying to delete records in a linked text file. That flipped
open notebook indicates that the table is a linked text file. I don't believe you can delete records in a linked text file. At least my ACCESS 2002 program says such deletions are not supported by the ISAM for text file linkages. -- Ken Snell MS ACCESS MVP "Tina" wrote in message ... I'm sorry to be a pain in the hmhm. I tried your suggestions. It is still not working. I double checked both tables, names, field names etc.. for case sensitivity. I am able to see the records that art to be deleted in datasheet view, so I know they are being located with the query. But, for whatever reason, once I hit "Delete" I keep getting the "Could not delete blah blah blah". As far as I know, Linkbase is not linked to any other tables. It does have a different Icon in front of the name, it has a little flipped open notebook where the other tables all have the little data sheet. I don't have a clue why! Anyway anything else you can think of would be greatlty appreciated! Tina -----Original Message----- Tina, Is the table Local (local means that is not a linked table to another database)? If not, try to put the bracket around the Linkbase.NUMBER. Also make sure the table Linkbase has the field "NUMBER" in there (Access is Case sensitive). I hope this helps. Like this: ======================================= DELETE Linkbase.* FROM Linkbase WHERE [Linkbase].[NUMBER] IN (SELECT [Linked Deletions18-1].[Number] FROM [Linked Deletions18-1]); ======================================== -----Original Message----- Ken, Thanks for your help! I tried your suggestion and I am still getting the same error msg. Do I have some kind of block on the "linkbase" table that I am unaware of ???? Tina -----Original Message----- You need to put the "joined" table into a subquery so that only one table is in the main SQL statement: DELETE Linkbase.* FROM Linkbase WHERE Linkbase.NUMBER IN (SELECT [Linked Deletions18-1].[Number] FROM [Linked Deletions18-1]); -- Ken Snell MS ACCESS MVP "Tina" wrote in message .. . 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? . . . |
#8
|
|||
|
|||
Try:
DELETE Linkbase.* FROM Linkbase, [Linked Deletions18-1] WHERE (((Linkbase.NUMBER)=[Linked Deletions18-1]. [Number])); -- HTH Van T. Dinh MVP (Access) "Tina" wrote in message ... 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 |