>Dear All,
>My network uses peer to peer and the switch hub is used for the network. The forms opening with many Sql squeries by one station is very fast and the data display will complete less than 1 second but two stations or more stations opening same form is very slow and each station takes several seconds to complete the data display in a form.
>
>I also put the same program and data in other similar network enviroment and it comes out the same problem.
>
>Form opening for one station is fast but slow down signicantly for two or more stations for same form.
>
>Can anyone encounter such problem? Please advise any solution to solve the problem.
This kind of problem has often been attributed to antivirus software. Turn your antivirus software off (temporarily, of course!) to verify this. If this turns out to be the problem, see if you find an option to exclude DBF and related files from virus-checking. Or try another antivirus product.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)