>
>I hear ya. Before even starting with such a conversion, I would get access to a computer running SQL Server or download SQL 2005 express http://msdn.microsoft.com/vstudio/express/sql/download/
>and see if you can transfer that data out of SQL and into a grid at a speed that would be acceptable to your users. You might be surprised how fast SQL can serve the data then transfer it to the client. You could even do the old VFP trick of loading all the parts when the users starts the app and then storing it locally... then just any newly add parts when they open the browse screen.
>

I do have SQL 2005 on my PC. It is a good suggestion, I believe, to see how long it would take to download 10K or 20K or records in the LOAD of a form. Although, to be more practical for a future customer, I have to have a separate server with SQL 2005 to account for network traffic.

>For me, the users gave up the huge scrollable grid when I gave them an incremental search where they could type in a partial string match then hit search to pull back the matching data. Then they could keep typing in more of the string to narrow their search. They always have the choice of typing in no partial match then hitting search to bring back all of the data... they know this will take 1-5 seconds versus a split second. I'm just glad that I never implemented this incremental search in the pure VFP app, then I would have been stuck. :-)

I have these incremental searches all over my application, so I guess I am stuck :). But I won't give up.

Thank you.