>>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?
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison