>Hi all,
>
>I’m looking for someone who can nursemaid me through a learning process. I have a medical claims processing system that I wrote, and am trying to rectify some mistakes that I made at the beginning of the design. Being self taught, I was not aware of all of the client/server data transfer issues that would crop up when the number of users began to increase.
>
>Basically, my system was built for only a few users. At the time, I did not understand about C/S remote access and how to set it up. Now that is coming back to haunt me (25 users and horrible response time). In a nutshell, the aspects of my application are as follows:
>
>• My application is written in VFP 7.0
>• All tables are members of one database.
>• I have no views or remote connections, only tables.
>• My Database and Tables reside on our server (Microsoft Windows 2000 Server). I have the executable version of the application loaded on each individual workstation. The data is then retrieved from the server.
>• All of the needed tables and relationships are defined in the DataEnvironment of each form.
>• I have no SQL in my programs.
>• I have approximately 25 tables, with each table containing tens of thousands of records.
>
>My main question is: Are there some relatively simple steps I can take to convert my data access from local to remote, or am I looking at a major revamping?
>
>Thanks in advance for your help. U.T. has been an invaluable resource for me over the past few years.

There is a good book published by Hentzenwerke on making client-server application with Visual FoxPro and SQL-Server

http://www.hentzenwerke.com