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?




.

.

.



.