Re: D3/NT - Auto logoff from inside ERP application ideas pls

I think the OP wants more than just a timeout - he wants to check that the
user isn't actually doing anything (I think by checking that there are no
locks).

I don't know D3 but I guess it's possible to write such a utility, which I
presume could run as a phantom and therefore not take a licence itself.

I'm sure it's also reasonably easy to put together. Not sure if he's
asking how to do it, of if he's looking for some consultancy to have the
utility writtten for him though.

Regards
Simon

--
================================
Simon Verona
Dealer Management Service Ltd
Stewart House
Centurion Business Park
Julian Way
Sheffield
S9 1GD

Tel: 0870 080 2300
Fax: 0870 735 0011

"Mike Preece" <michael@xxxxxxxxxx> wrote in message
news:1153915944.184436.262210@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Check the ref man for the timeout verb.

johnmarshall@xxxxxxxxxx wrote:
Hi
we have a 20 user D3/NT system running an ERP package for manufacturing
and we keep running out of logins.
We can't afford to buy a whole heap of extra user licences for the ERP
package, and in fact, at any given time many of the users are inactive
or away from the desk so we need a method of managing the logons to
keep them pruned of inactive users.

The ERP system comes with a menu program written in Pick Basic, and we
got that modified so that anyone sitting at menu level gets purged
after 10 minutes of inactivity. That didn't help as much as we hoped
for as we have lots of users who sit inside enquiry screens or even at
TCL, and we need some way of automatically getting rid of them.

The ERP system has a locked items master file, so it is possible to
theoretically deduce who is doing data entry / locking records.

I'm now wondering if I should get a program written that runs as a
phantom process and monitors logons and after say 1 hour of a user
being logged in and no records locked in the ERP locked items master it
logs off the user.

Any comments / suggestions?

regards
John Marshall
Christchurch NZ



.

Relevant Pages

  • Re: D3/NT - Auto logoff from inside ERP application ideas pls
    ... Simon Verona wrote: ... We can't afford to buy a whole heap of extra user licences for the ERP ... after 10 minutes of inactivity. ... The ERP system has a locked items master file, ...
    (comp.databases.pick)
  • Re: D3/NT - Auto logoff from inside ERP application ideas pls
    ... Simon Verona wrote: ... We can't afford to buy a whole heap of extra user licences for the ERP ... after 10 minutes of inactivity. ... The ERP system has a locked items master file, ...
    (comp.databases.pick)
  • Re: Biztalk ERP integration questions
    ... Incoming orders from various partners in various formats (some XML, ... table in our ERP database; 2) generate new customer order number using ... and 2) import transactions into this ERP system given the 2 built-in ...
    (microsoft.public.biztalk.general)
  • Re: Permissions
    ... The ERP may be using trusted connections. ... >B logs into the OS and the ERP, then logs out of the ERP, ... >Wayne Snyder, MCDBA, SQL Server MVP ... >> We use an SQL backend ERP system on our Windows Small ...
    (microsoft.public.sqlserver.server)
  • Re: Permissions
    ... The ERP may be using trusted connections. ... Also there may be some issues related to connection pooling.... ... B logs into the OS and the ERP, then logs out of the ERP, the ERP continues ... settings (as per he ERP system documentation) and see if that helps... ...
    (microsoft.public.sqlserver.server)