Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Not allowing multiple users...
Message
 
À
10/11/1999 12:28:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00289588
Message ID:
00289691
Vues:
23
Yep, your post jogged my memory. Been putting resource files local so long (FP1.02 days) forgot about this. I'll take an official fish-slap for my bonehead reply as well :-)


>>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?
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform