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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

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,136,347
Messages
5,675,235
Members
419,555
Latest member
Paddington

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