I have set up a user on my server 2003 to access an MS Access database that is located in the users startup folder. Lets call this user "Bill". Bill connects to the server through a web browser using the tsweb (e.g. IP address/tsweb). When Bill connects he gets the Server 2003 log on screen. When he puts in his username and password the MS Access database starts up automatically. Bill can then use the MS Access database as if he was in his office at work.
If Bill was to give his username and password to a collegue, and that user enters in Bill's details at the Server 2003 log on screen, Bill's screen freezes and eventually logs him off saying that somebody else has connected. Is there any way that the Server can detect that somebody is already connected and disallow the second user from accessing the system?
Thank you in advance,