Re: Temporary table with SQL Server 7.0



rst.Open "select * from #tmp1"

That line SHOULD generate the error you described: you did not specify
the connection

Good catch. I missed that.

Stephen Howe


.