In general, the multi-user access always will be slower than single-user. Incorrectly configure anti-virus could contribute to it as well. Make sure that table files (dbc, dbf, cdx, fpt, etc) are excluded from real-time scanning. Also make sure that ops locks are disabled on the "server".
>My network uses peer to peer and the switch hub is used for the network. The forms opening with many Sql queries 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 environment and it comes out the same problem.
>
>Form opening for one station is fast but slow down significantly for two or more stations for same form.
>
>Can anyone encounter such problem? Please advise any solution to solve the problem.
--sb--