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 ...

I'm pretty much a beginner when it comes to SQL Server administration, so I'm kinda in the dark here.<BR><BR>BTW, both servers use SQL Server 2000. More options Report Add bookmark Share ...