>>I understand the difference between file system and C/S. I have an app that I want to convert to SQL Server 7 and would like to minimize the amount of conversion coding.
>>Thanks!
>
>David,
>
>I can appreciate your desire to minimize the recoding needed. But even though I can, I till say that the data access is one area that you should spend time redoing when you move from local data to C/S.
>
>It analogous to being in the gardening business with a pickup truck and then changing your business to paving but trying to get away with using the same pickup truck. It can be done, but it is far from the optimal solution.
That is why I wanted to move to using views instead of SQL Pass-Through. I agree that with a table of 3 million records I will have to use parameters in order to get any performance.
Thanks!