Hi,
I am beginner of multiuser application. I was trying to access my file from file server. Could you tell me which is better way ?

First method:

Main.prg

SET PATH TO \\myserver\c\mypath

FORM.INIT()

USE mytable AGAIN SHARED
CUSSORSETPRO("BUffering", 5)

SELECT * FROM mytable WHERE condition = mycondition INTO CURSOR mycsr

Second Method:

FORM.Init()

SET PATH TO \\myserver\c\mypath
USE mytable AGAIN SHARED
CUSSORSETPRO("BUffering", 5)

SELECT * FROM mytable WHERE condition = mycondition INTO CURSOR mycsr

After my simple testing, I found that, it take 6 seconds to load 500 records in 10BASET network. However, the 2nd ways not return consistant result. It may take 6 seconds, or... 2 seconds sometime. Why? I reboot my computer everytime after a test. Again, 2nd method will take 6 seconds to load data after the code with 1st method is executed.

Any ideas?

Thank you