Who is logged onto MS Access or LAN
Posted on 2009-07-09
I have 150 staff using an Access 2003 database with a SQL backend.
I would like to find out which users are still logged onto the network, or onto MS Access when a certain task needs to be performed. This task is usually performed by one person, but in their absence ( out to lunch, on vacation, gone home etc ) there are 6 other people who can perform this task, unfortunately they are located on different floors and in different buildings, so knowing who to reassign the task too is difficult.
Can Access ( on a click of a button ) check to see if person 1 is still there and if not, check to see if person 2,3,4,5,6 is still logged on and assign them the task instead ?