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

A more SQL-compatible way of doing things is to load each of the parameters into an in-memory table. It's much easier to integrate that table into any of the queries in your stored procedure. The ...

I tried this in the past, but didn't have any luck.Is it possible to create a temp table on a remote server?Situation:I have to run a group of queries against a remote server.The first query is a ...