>Samuel,
>
>The fastest access in my experience is using SQL passthrough utilizing SQLPrepare statments, then SQLExec.
>
>HTH,
>Ed
You're still using ODBC. Using stored procedures on SQL Server is the fastest after the first time it is runned. I am still learning how to use stored procedures so if anyone has any tips please let me know! Thanks!
DLC