>>>>>Im trying to make form a stand allone application a multiuser and I have some problems.
>>>>>
>>>>>In one form there is a problem with a relation between two tables.
>>>>>The Buffermode form table 1 = 3 and from the other is 1 And the datasession = 1 Default datasession.
>>>>
>>>>What is the problem? Could you give us some details?
>>>
>>>The problem occurs when the program is in the network and I'm trying to reach from two computers for the same record. The error is in the relation between the two tables with a buffermode of 1 and 3
>>
>>What error message and/or number do you get? Or, what is the unexpected behaviour?
>
>
>I'm working in vfp 6.0. We have a screen with the next futures:
>- tables are #5 optimistic table buffering
>- formset is buffermode 2 optimistic
>- data session is 2 private
>- readlock is false
>
>When we open this form at the same time the program coudn't load the formset. And the message is: ERROR LOADING FILE ..... FILE ACCES IS DENIED.
>
>I hope some one can help me with this problem.
>
>Thijs

For multi-user access, SET EXCLUSIVE must be OFF (or you must explicitly open all your tables with USE ... SHARED. If EXCLUSIVE is ON, and you open a table on one workstation, no other workstation may access that table at the same time.

Some buffering modes require that SET MULTILOCKS be ON.

Finally, if you're working on a Novell network, you must mark all table-related files to be Shareable (i.e. .DBF, .FPT, .CDX) as well as database container files .DBC, .DCT, .DCX and any other files that may be opened by more than one user at once.