A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Could not delete from specified table"



 
 
Thread Tools Display Modes
  #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?


Ads
  #2  
Old September 30th, 2004, 05:32 PM
Ken Snell [MVP]
external usenet poster
 
Posts: n/a
Default

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  
Old September 30th, 2004, 05:41 PM
Van T. Dinh
external usenet poster
 
Posts: n/a
Default

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?




  #4  
Old September 30th, 2004, 06:01 PM
Tina
external usenet poster
 
Posts: n/a
Default

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  
Old September 30th, 2004, 06:43 PM
JL
external usenet poster
 
Posts: n/a
Default

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  
Old September 30th, 2004, 07:51 PM
Tina
external usenet poster
 
Posts: n/a
Default

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  
Old September 30th, 2004, 10:03 PM
JL
external usenet poster
 
Posts: n/a
Default

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?




.

.

.

.

  #8  
Old September 30th, 2004, 10:30 PM
Ken Snell [MVP]
external usenet poster
 
Posts: n/a
Default

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?




.

.

.



  #9  
Old September 30th, 2004, 10:52 PM
Tina
external usenet poster
 
Posts: n/a
Default

Thanks so much! I re-imported Linkbase (a text file)and
as a regular table. I was then able to do the delete
query and it worked!!!! I don't know how I ended up with
a linked text file in the first place.

Thanks again,
Tina

-----Original Message-----
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?




.

.

.



.

  #10  
Old October 1st, 2004, 12:10 AM
Ken Snell [MVP]
external usenet poster
 
Posts: n/a
Default

"Tina" wrote in message
...
I don't know how I ended up with
a linked text file in the first place.


It's an easy mistake to make...just a few centimeters difference between the
two menu options in File | Get External Data ... option.
--

Ken Snell
MS ACCESS MVP


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 11:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright ©2004-2018 OfficeFrustration.
The comments are property of their posters.