View Single Post
  #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?




.

.

.