I've just started using MS Access 2007 heavily the past few days (after not having touched it since 2000). My issue is that I have written a query in SQL view that takes about 60 seconds to return ...

This is VB6 and Access 2000. The following code snippet very nicely calls a stored query in an Access database: conn.Open "dbtest" Dim rsTemp As ADODB.Recordset Set rsTemp = conn.Execute("Query1") If ...