>I know, I hate all those paraenthesis. When I'm doing testing though I usually just create my queries in Microsoft Access and then paste the SQL into my VB code and then rewrit it to more acceptable once know it is wrking properly. Saves a bit of time is all when your trying to stumble through something.
Did you try using the connection object to execute the SQL Statement? It would return a forward-only, read-only RS anyway. It would go something like this:
Set rstTest = cnCreateReportTable.Execute "SELECT * FROM #tblNewNames"
Not that it should make any difference, just something to try.