Posted by Erland Sommarskog on 11/26/05 14:19

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]