You can create local and global temporary tables. Local temporary tables are visible only in the current session; global temporary tables are visible to all sessions.
What if you try using stored procedure for your stuff?
(So this way it will be shure that's in the same session, well if not, we have a problem...)
Like:

(SQL)
CREATE PROCEDURE sp_Test
AS
SET NOCOUNT ON
SELECT 
    output_file.* 
INTO 
    #tblNewTables 
FROM 
    output_file
WHERE 
    output_file.Phys_Num = '000303'

-- Part II
SELECT
    * 
FROM 
    #tblNewNames

and then call your sp in your code like:
(you will need a command object)

set cmd.ActiveConnection = (Your connection obj)
cmd.CommandType = adStoredProc
cmd.CommandText = "sp_Test"
set rs = cmd.Execute

Hope this will help (and work...).
Patrice Merineau