Posted by Terry Kreft on 11/26/05 14:51

In Access you can use SQL Passthrough queries.

These pass the raw SQL thriough to the server which processes the request
and returns the results.



--
Terry Kreft



"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns971A872FB83DFYazorman@127.0.0.1...
> maxzsim via SQLMonster.com (u14644@uwe) writes:
>> kindly ignore this as i found what i wanted from the BOL. I have just
>> found out that the query itself is quite fast after tracing thru the
>> codes. This query insert data into a temp table. The problem happens
>> when the report from MS Access is formatting the data not only from the
>> temp table but also SQL table.
>>
>> How is it possible to create a ADO connection that can be used by ms
>> access report instead on relying on the odbc-linked table ?
>
> Maybe it's time to inquire in an Access newsgroup? At least, I have
> nothing to suggest, as I don't know Access.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]