Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Not allowing multiple users...
Message
De
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:
00289671
Vues:
21
>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?
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform