>Hi Greg,
>
>Just a WAG but maybe the resource file is being opened exclusively. Try moving SET EXCL OFF before the SET RESOURCE TO.
>
The resource file is _always_ opened exclusive, unless the file is flagged Read-Only. If the user needs to write to the FOXUSER, then each station needs it's own FOXUSER.
One kludgy way to do this is:
cStationName = ALLTRIM(LEFT(SYS(0),AT('#',SYS(0)))
IF ! FILE('\\apps_svr\apps\apps\training\'+cStationName+'.DBF')
USE ('\\apps_svr\apps\apps\training\foxuser6') SHARED ALIAS (SYS(2015))
COPY TO ('\\apps_svr\apps\apps\training\'+cStationName)
USE
ENDIF
SET RESOURCE TO ('\\apps_svr\apps\apps\training\'+cStationName)
You could run the code above unconditionally if you wanted all users to start with a 'fresh' FOXUSER each time.
>>I am working on an application which is nothing more than a Training database. I am having trouble getting the executable to allow more than one user at a time.
>>
>>The following code is in my INIT of the main screen:
>>
>>_SCREEN.VISIBLE=.F.
>>SET RESOURCE TO \\apps_svr\apps\apps\training\foxuser6.DBF
>>SET DEFA TO \\apps_svr\apps\apps\training
>>SET EXCL OFF
>>OPEN DATABASE training
>>SET DATABASE TO training
>>
>>
>>I have even checked the Novell network properties to ensure that the Training.exe and foxuser6.* are shareable.
>>
>>I have checked in the project and go to Tools - Options - Data and the Open Exclusive box is NOT checked.
>>
>>What am I missing?