MS Access Query - specify table i want to delete from

[JonHuff]

i am getting an error try to run query:

DELETE *
FROM tblExceptions INNER JOIN tblTemp3 ON tblExceptions.ExceptionKey=tblTemp3.ExceptionKey
WHERE (((tblExceptions.ExceptionLevel)=0));

it says to specify table to delete from?

[dsatino]

I don't think you can use the * with DELETE queries that have a JOIN because both tables have a * option.

Your query doesn't specify which tables * you want to delete.

You could try to modify the SQL to DELETE tblExceptions.*

But I have no idea whether Access will recognize what you are trying to do

[MMcCarthy]

Essentially you can't use a delete query on a query with a join like this. Try this instead ..

DELETE * FROM tblExceptions
WHERE ExceptionKey=DLookup("[ExceptionKey]","tblTemp3","[ExceptionLevel=0");