Thanks

>G'Day Petras, < g >
>
>>Hi, I have a VFP6 (SP5) application that opens a local VFP database that purely consists of remote views. As we all know, this database can become corrupted by PC crashes, [Crtl][Alt][Del] etc. Questions:
>
>You just gotta love those Remote Views don't ya! < s >
>
>>2) Is there any method of changing the way remote views are recreated? Currently when recreating remote views, each view seems to be generating an SQL command of "SELECT * FROM table" which on large tables and on a WAN can take a long time (several minutes).
>
>Yikes!!! Talk about negating the whole "reducing network traffic" effect that client server apps have. What you need to do is re-work those views so that they only bring down the field required and/or add a parameter to them to reduce the number of records retrieved.
>
>Either way, you're learning the hard way that RVs are no fun!