I looked at Joy's code. The speed differences were due to Rushmore, not ODBC in general over direct access.
>Dear Craig and Joy,
>
>I'm interested to hear the end of this thread and the results of your tests. Did you establish circumstances under which one method was faster than the other?
>
>Ben
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer