When you create a table, it's open exclusively unless you close and reopen it. In other circumstances check SET TABLEVALIDATE in help. The follow setting may fix the problem.
SET TABLEVALIDATE TO 7
>Let's say I do the followings:
>- open an instance of Visual FoxPro
>- create a table "tabtest" and enter some data
>- issue a FLOCK() on that table
>- perform: "SELECT * FROM tabtest" and I get the data
> Everything's OK so far.
>
>If I open another instance of Visual FoxPro (the previous instance is still opened) and try the same query: "SELECT * FROM tabtest" I get the error message that the file is in use by another user. (SET EXCLUSIVE is OFF in both of the situations)
>Can someone, please, explain to me this type of behaviour because in FPD 2.6, in the same situations, I was able to run that query.
>
>Thanks
--sb--