Hi!

One more suggestion...

What is a query for that view? Is it like "SELECT * ..."?
If yes, VFP could query a list of fields and their types for such data set from a server, that can take a lot of time. Just try to change the query to query a field list instead of * (in view designer this is easy to do when you change order of fields selected).

>Is that normal ?
>
>I use Win98, MSDE, Visual Foxpro 7.0. I work with remote views in my application. After creating the connection, and a simple view to specific table on MSDE, the connection to the sql-server is fast. But when developing and testing the application, each time when a view is opened, the "opening" time of the view is a little bit slower (approx. 3 to 5 seconds).
>
>If I delete the connection and rebuild the connection, the "opening" time of the view is fast again.
>
>What can be possible reason for that ?
>
>Bye,
>-Andreas