Could Not Delete from Specifid Tables

[blizkij]

Hi,

I'm running a delete query based on 2 tables (requesthours and refresh_date) and deleting based on requesthourse.last_mod_date being greater than refresh_date.date. It works fine in the previous however I get the error Could Not Delete from Specified Tables.

DELETE tbl_RequestHours.*, tbl_RequestHours.last_mod_dt
FROM tbl_RequestHours INNER JOIN tbl_refreshdate ON tbl_RequestHours.last_mod_dt = tbl_refreshdate.date
WHERE (((tbl_RequestHours.last_mod_dt)>([tbl_refreshdate].[date])));

nikki

 

[cmmrfrds]

The delete syntax.

DELETE
FROM tbl_RequestHours INNER JOIN tbl_refreshdate ON tbl_RequestHours.last_mod_dt = tbl_refreshdate.date
WHERE (((tbl_RequestHours.last_mod_dt)>([tbl_refreshdate].[date])));