Message: "Could Not Delete from Specific Tables"

[Guest]

I keep getting this message while running a delete query. Using two tables...
T_CaseNbr and T_ACISLog.

I want to delete all records in T_CaseNbr Where T_ACISLog!CASE =
T_CaseNbr!CaseNbr.

Seems simple enough. But I keep getting the message I noted in the subject
line.

What am I missing? Thanks for your help.

Connie

 

[Guest]

Make a complete backup first!

DELETE T_CaseNbr.*
FROM T_CaseNbr
WHERE EXISTS (SELECT "X"
FROM T_ACISLog
WHERE T_ACISLog!CASE = T_CaseNbr!CaseNbr);

 

[Guest]

I'm a little confused what you mean by (Select "x") this is what I currently
have:

DELETE T_CaseNbr.*, T_CaseNbr.EMPLOYER_NUMBER
FROM T_ACISLog LEFT JOIN T_CaseNbr ON T_ACISLog.CASE =
T_CaseNbr.EMPLOYER_NUMBER
WHERE (((T_CaseNbr.EMPLOYER_NUMBER)=[T_ACISLog]![CASE]));

I think I called the T_CaseNbr.EMPLOYER_NUMBER, T_CaseNbr.CaseNbr in my
first post. Sorry.

 

[John Spencer]

Try the following modification

DELETE DistinctRow T_CaseNbr.*
FROM T_ACISLog INNER JOIN T_CaseNbr
ON T_ACISLog.CASE = T_CaseNbr.EMPLOYER_NUMBER


If that fails then you can try
DELETE DistinctRow T_CaseNbr.*
FROM T_CaseNbr
WHERE T_CaseNbr.EMPLOYER_NUMBER
IN (SELECT [T_ACISLog]![CASE]
FROM T_ACISLog)

I'm a little confused what you mean by (Select "x") this is what I
currently
have:

DELETE T_CaseNbr.*, T_CaseNbr.EMPLOYER_NUMBER
FROM T_ACISLog LEFT JOIN T_CaseNbr ON T_ACISLog.CASE =
T_CaseNbr.EMPLOYER_NUMBER
WHERE (((T_CaseNbr.EMPLOYER_NUMBER)=[T_ACISLog]![CASE]));

I think I called the T_CaseNbr.EMPLOYER_NUMBER, T_CaseNbr.CaseNbr in my
first post. Sorry.

Make a complete backup first!

DELETE T_CaseNbr.*
FROM T_CaseNbr
WHERE EXISTS (SELECT "X"
FROM T_ACISLog
WHERE T_ACISLog!CASE = T_CaseNbr!CaseNbr);

 

[Guest]

Thanks so much for your quick response. I'll try your suggestions and report
back.

Try the following modification

DELETE DistinctRow T_CaseNbr.*
FROM T_ACISLog INNER JOIN T_CaseNbr
ON T_ACISLog.CASE = T_CaseNbr.EMPLOYER_NUMBER


If that fails then you can try
DELETE DistinctRow T_CaseNbr.*
FROM T_CaseNbr
WHERE T_CaseNbr.EMPLOYER_NUMBER
IN (SELECT [T_ACISLog]![CASE]
FROM T_ACISLog)

I'm a little confused what you mean by (Select "x") this is what I
currently
have:

DELETE T_CaseNbr.*, T_CaseNbr.EMPLOYER_NUMBER
FROM T_ACISLog LEFT JOIN T_CaseNbr ON T_ACISLog.CASE =
T_CaseNbr.EMPLOYER_NUMBER
WHERE (((T_CaseNbr.EMPLOYER_NUMBER)=[T_ACISLog]![CASE]));

I think I called the T_CaseNbr.EMPLOYER_NUMBER, T_CaseNbr.CaseNbr in my
first post. Sorry.

Make a complete backup first!

DELETE T_CaseNbr.*
FROM T_CaseNbr
WHERE EXISTS (SELECT "X"
FROM T_ACISLog
WHERE T_ACISLog!CASE = T_CaseNbr!CaseNbr);

--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


:

I keep getting this message while running a delete query. Using two
tables...
T_CaseNbr and T_ACISLog.

I want to delete all records in T_CaseNbr Where T_ACISLog!CASE =
T_CaseNbr!CaseNbr.

Seems simple enough. But I keep getting the message I noted in the
subject
line.

What am I missing? Thanks for your help.

Connie