By using the nomenclature #localtable or ##globaltable SQL Server knows to create a table in TempDB. If you use a local temp table, it is only available for your current session.

Then they're there, no one knows it, and you can use the full functionality of Access.<BR><BR>When you're done, you might do a benchmark between using the temp table versus sql server to see if it ...