>>>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.
>>------------
>>ok - so the best and the fastest way to do this, is to have the remote views
>>on the user's pc, delete the contents of the remote views when the user
>>exits the program, and update the views when the program is loaded.
>>it that right?
>
>You can do this, but I don't understand why would you delete the data on the server every time the view is populated?
--
I am not going to delete the data on the server, I would just delete the
data in the remote views for security sack. These remote views live on the
user's pc. what do you think?