MSACESS 2000
FORM

Problem: I have two tables one which has approx 1 million records(tbl1) and another which has approx 400,000(tbl2). I am trying to remove entries in tbl1 that dont have a corresponding value in tbl2. I have tryed doing a sub query(DELETE FROM tbl1 where field1 NOT IN(select field1 from tbl2) but the system just freezes and doesnt actually delete anything.

I have come up with the idea that i can use two seperate loops and two recordsets to accomplish this but i need a way to stop the system from freeze while im doing this neideas?