See who has an Access database open.

[Deb6508]

Hi,
I know I am probably in the wrong board but was hoping someone here could help me. Does anyone know of a way that I could see who would be currently logged into my database?

Thanks for any help you can provide since we seem to have inquiring eyes here and odd things happening. I will be password protecting everything but need to find out who would be in now currently.

Deb

 

[Andrew Fergus]

Hi

Have a read of the links from CT Witter at the bottom of this thread :
http://www.mrexcel.com/board2/viewtopic.php?t=193007

I believe that will do what you want.

Andrew

 

[sam slade]

Grab the user by the environ(s)

Hi Deb6508,

I always found it best to build a log in script to ascertain who was 'logging in'. This used to be a startup form "Please enter name/password if necessary" BUT this didn't work in my company as everyone had access to everyone elses userid anyway. You can even prohibit certain users by checking an allowed/disallowed table if you're using multiple front ends with a single backend.

What i found worked was getting the windows login name from the environ parameters (honest this is easily done), then creating a table of who was logging in and when.

I then went a step further and developed a script to check if the user had the db open BUT not using it for some time...eg lunch, phone call, fell asleep etc. The db could then close itself to that user.

These ideas worked very well in a Contact Centre of more than 300 users, working shifts over 24 hours.

BUT wait wwhat about new users who don't see your email coz they weren't logged in...You could set a txt file with a flag to say if the db could be opened at all...great for maintanence issues.

Hope these ideas are of help...If you need any elaboration, pls ask

Sam