>>>I am writing a procedure to perform maintenance functions on tables which are accessed by a FoxPro 2.6 for Windows application. The application and the data are installed on a Novell Netware 4.11 network. Users of the application are asked to close the application before going home for the night but they don't always comply. If the maintenance procedure is unable to open a table exclusively, I would like to be able to log the identity of the user so that he or she may be sent a reminder.
>>>
>>>Can anyone suggest how I can identify the user (in FoxPro code)
>>>
>>>James McIlwrath
>>>Mississauga, ON
>>
>>In the system log-in script of NetWare, you can create DOS environment variables such as SET USERID="%LOGIN_NAME". In the FoxPro app, you can then obtain the user's Novell ID by the following:
>>
>>cUserID=GETENV("USERID")
>>
>>No need for third party libraries...
>>
>>Jack Mendenhall
>>Reinsurance Management, Inc.
>
>Jack,
>
>That's fine as long as security isn't a concern. Users can change DOS environment variables.

I doubt that you will encounter that many knowledgeable users. And if they can do that, they could probably also open Fox tables with ODBC. So then Fox is a security issue, too...

Jack