See who has an Access database open.

Deb6508

Board Regular
Joined
Oct 25, 2004
Messages
131
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
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

sam slade

New Member
Joined
Sep 14, 2006
Messages
22
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
 

Forum statistics

Threads
1,171,169
Messages
5,874,155
Members
433,029
Latest member
theodoros1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top