Yeah, I had this all worked out with SPT 2 years ago. But they wanted to remove all UI out of the solution so that they could control the process from other components. No sweat. But then the ADO restriction and the SP restriction.....jeez, Louise....
BTW, on first pass, using Find and one general Open as opposed to doing an Open for each specific code lookup increased the speed by a factor of 5-6 per pass.
>Good luck!! I guess if they make their bed, they will need to lie in it. Let 'em deal with the poor performance. Maybe they will then concede that using a SP is the way to go. Or, maybe they will concede that SPT was not so bad...
>
>Either way, you win...< bg >...
>
>
>Is being a consultant just grand or what???!!!!
------------------------------------------------
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