My old friends, I would appreciate your assistance in solving my current dilemma. I'm looking to make an access report that is dependent on data from a remote SQL Server. Additionally, I want to run ...

If the collation of the server and the specific database of the SQL Server differs, then when using temporary tables, the error "Cannot resolve the collation conflict ...

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