I have a temp table that I would like to remove rows from if the value of one of the columns matches a query result.
If I view that in the datasheet view I only see matching Task as expected. But if I try and run the delete query it gives the error "Could not delete from specified tables" I feel like am missing something simple in this process.
SQL:
DELETE Task_Temp.*, CompletedTask.TaskNumber
FROM Task_Temp, CompletedTask
WHERE (((CompletedTask.TaskNumber)=[Task_Temp].[TaskNumber]));
If I view that in the datasheet view I only see matching Task as expected. But if I try and run the delete query it gives the error "Could not delete from specified tables" I feel like am missing something simple in this process.