Buddy -- Thanks. I'll give it try. Peter
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Walker, Buddy Sent: Wednesday, October 29, 2008 3:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Mult-iusers, Multi-sessions, Mult-iPCs Peter You could create a table (ctrlTable) with the following columns computerName TEXT 25 DateTimeIn DATETIME DateTimeOut DATETIME CONNECT YourDataBase SET VAR vComputerName = (CVAL('Computer')) SET VAR vRows INTEGER = 0 SEL COUNT(*) INTO vRows INDIC ivrows FROM ctrlTable WHERE computerName = .vComputerName AND DateTimeOut IS NULL IF vRows <> 0 THEN PAUSE 2 USI 'Already Logged In' CAPTION 'TEST LOGIN' ICON STOP GOTO Done ELSE INSERT INTO ctrlTable (computerName,DateTimeIn) .vComputerName,.#NOW ENDIF Make sure you update the DateTimeOut when exiting the database. Buddy ________________________________ From: [email protected] on behalf of Peter J. Ryan Sent: Wed 10/29/2008 4:35 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Mult-iusers, Multi-sessions, Mult-iPCs We have several computers in a common counter area. Users loggin to apps to assist customers. Sometimes at their own desk Sometimes at the counter. Often at both places all day long. I am trying to find a way to limit the use of the same database being opened more than once on the same PC. Timeout option doesn't seem to be the issue -- its preventing the start of a session that already opened. (Re-training users and/or replacing the staff is an option desired but -- I really can't consider it now.) I guess mystartup.dat is missing sometime. Suggestions? --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
