A common SQL habit is to use SELECT * on a query ... them to be performed as low-priority background operations. Use temp tables to improve cursor performance For the most part, cursors should ...

Create a query from within Access that attaches to my SQL Server and retrieves ... Take that recordset and use it to create a new table (a temporary one) in the local Access database.< ...

So, it looks like you can't do a statement like this:<BR><BR>IF <BR> SELECT *<BR> INTO #Temp<BR>ELSE<BR> SELECT *<BR> INTO #Temp<BR> WHERE....<BR><BR>What the best way to work around this?