Error Message: There is already an object named '#rsTmp'
in the database.

My code checks for any active connections as one of the
first steps and closes them.  So why would it still be
there?

Code:

TmpSelect = "Select Mast.fsono, Item.fline Into #rsTmp
From Mast, Item Where Upper(Mast.fSono) Between '001408'
AND '001408' AND Upper(Mast.fSono) = Upper
(SoItem.finumber)"

With cmdTmp
    .ActiveConnection = cnClient  'Client-side connection
    .CommandText = TmpSelect
    .CommandType = adCmdText
    .Execute
End With

Could be you're reusing a pooled connection.  You could try adding SQL to
check for the existence of the temp table and drop it if it shows up before
the select ... into, like this:

TmpSelect = "if object_id('tempdb..#rsTmp') is not null drop table
#temptable Select Mast.fsono, Item.fline Into #rsTmp... "

--
Bob
Microsoft Consulting Services
------
This posting is provided AS IS with no warranties, and confers no rights.