I have two tables. One table is a table I maintain with maybe 10 policy ids. The other table is created everyday from system data that is generated into excel and I import into a table in Access. I want to write a query that will delete those 10 policies every time I pull in new data. I've attached an image of my query design. When I try to run this I receive an error message "Could not delete from Specified Tables." This query need to be part of a macro that is ran everyday.
Any help will be greatly appreciated.