>I want my existing USE,APPEND,SEEK ETC. to use Sql tables without using a local or remote connection. Becuase my existing apps does'nt use local or remote view.

Well, at a minimum, SEEK() is going to be tough - the indexes on the backend are not reflected to act as native VFP-style indexes running at the client. USE and APPEND are directly supportable for RVs, SPT and now even ADO RecordSets via the ConnectorAdapter and ODBC or OLEDB. But you need to change your thinking considerably to work with a C/S backend; no longer should you try to work with entire tables of data directly; instead, have the app request that the backend select small subsets of data as defined by the current required app functionality, with the backend doing the process of selecting and updating the data store at its end so that if you do need to create traditional indexes at the client end, the indexes are small and created quickly.

The need to migrate our designs has been advised fro quite a while now; to take advantage of the new functionality in VFP from your apps, you have to reengineer away from monolithic ISAM-type operations.