Hi,

I use VB2005 as front-end, SQL Server as backend. Can we do create temporary table as "Create table #username ....................."?
when the user log off the program, then the temp table will be removed automatically, similar create temporary table in Query Analyzer, when close Query Analyzer, the temp table is removed.