Access VBA query hangs but equivalent table works fine
Posted on 2007-10-03
Access 2003 on WindowsXP:
(1) I ran the duplicates wizard to get Dups in a table on 2 fields, about 3,000 out of 170,000
(2) In a module I wrote a sub to open the DupQuery as a recordset, loop through it, build a SQL string to delete from the table the NumberOfDups -1
(3) The problem is it hangs halfway through requiring TaskMgr to abort
(4) I made the DupQuery a MakeTable query and ran it and it works fine.
Question: Why does the query cause it to hang, but the table based on it work fine?