Windows 7 & Access 2007 - Dire Query Performance

[Meltdown]

Hi All,

Are there any known issues with Access 2007(SP2) and Windows 7. I have an app that performs great on Win XP/ Access 2007 and dire on Windows 7.

Forms take ages to come up and now I have the following query which won't even run on Windows 7.

The code below returns about 1,500 records and executes virtually instantaneous on XP but just hangs on Windows 7, showing the 'running query' message in the taskbar, and eating up about 50% of my CPU.

I have to CTL+ALT+DEL out of it, because it never completes?

SELECT tblCompanies.Comp_Code
FROM tblCompanies
WHERE tblCompanies.Comp_Code IN (SELECT DISTINCT qryCRMSummaryTemp.Comp_Code FROM qryCRMSummaryTemp)

I might add that the SELECT DISTINCT qryCRMSummaryTemp.Comp_Code FROM qryCRMSummaryTemp query displays instantaneous.

Does anyone have any advice on how to debug this problem?

Thanks for any advice

- Melt

 

[wiklendt]

i've had a similar issue with Vista and Office 2007 but with a "NOT IN" rather than an "IN". mine took forever to finalise, and was worse because i had my queries nested. i changed mine to a frustrated join which made the queries appear instantaneously, but you could probably just use an inner or a left/right join with the right object. see the link and try out a similar thing with yours.