>Now I put my program in a computer equipped with Cyrix MII300, 64MB SDRAM, and using Ms WIN95 & WIN98 (ms networks client) to link up other computers using 10 baseT.
>
>The Network now have 5 user and the parent table have 6000+ records and children table have 12000+.
>
>Now the problem I run the program on the main computer (where the program installed), the program function very fast, however when I run the program at other computer, the program will work dramatically slow.
>
>Can you suggest any tips to improve the speed of the program??
>
>Any VFP or Ms WIN 95/98 setting will help the network speed??
Not too huge database for VFP in LAN. It seems your application doesn't use indexes enough and pumps entire database along wires. If you will ensure that you doesn't use non-optimized queries/commands and still is not satisfied with the speed - you should think about client/server model. First step can be DCOM, i.e. placing a business object to power machine and using it's methods/properties.