>>>Hi Nick:
>>>I have closed my view and open it again and I can still see the data. I would
>>>like this data to go away for good. How do I do that?
>>
>>If you have a remote view, next time you open it it retrieves the same data from the server. If you don't want this data in the back-end database you need to delete the records in the view and send updates to the back-end. Of course your remote view has to be updatable.
>------------
>ok - that is what I thought - but, what if I keep the remote views on the
>server? Will that work and will that be just as fast? - thanks

You cannot keep the remote view on the SQL server, because it is a part of VFP database which may be on local PC or somewhere on the network.