Have you considered using a remote view?
>While I think I can make that work, I prefer not to make the query resident in the database. It may be a last resort solution.
>
>>How about creating the query as a SQL-Server stored procedure, and then use SQLEXEC to execute that procedure?
>>
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05