Garry Robinson's form "frmJetUserRoster"

I recently purchased Garry Robinson's "Microsoft Access Database Protection and Security" book.  It's really an awesome book!!!

In one of his sample DBs, he included the form "frmJetUserRoster" which shows which users are currently logged into a database on a network.

The db application on our network does not have any security setup.   I believe that's why everyone shows up as "Admin" on Garry's fomr "frmJetUserRoster".

Does anyone know of a workaround to the form that shows me the user's "Windows Login ID"?  Or can you point me to another plug-and-play form that allows me the following:
- view who's currently logged into the db
- lock the db so that no one else can open up the db while some maintenance is performed.

Again, Garry's frmJetUserRoster does all that... except that I see everyone logged in as "Admin"... and the computer name does not do me any good.  


P.S.  I posted a sample db ( with Garry's form at URL 
Who is Participating?
Kelvin SparksConnect With a Mentor Commented:
I see the problem. I haven't used this tool before - was aware it existed. AIt may be a security issue in seeing into the registry of the remote PC. Generally, I'm only interested in the machine that has a database open, rather than whose logged onto it. Also tried the ldbViewer mentioned above - only got machine names back.

Seems that may be the best we can do
Kelvin SparksCommented:
Try this source
It may do whjat you're looking for
The link below is for free security wizard that might give you more flexibility.
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

TomBock2004Author Commented:
Thanks to both of your for the info... just some follow-up questions:

1: When I open another dabatabse from my machine and then view frmLdbViewer, I get the following error:  "Error 9: Subscript out of range" (actually, I get it twice... then it shows me some data).   Any idea what's causing it?
2: Once I get the info, it also shows me the Machine name... then, LoginName is "Admin" again.   Any idea as to how I can show the Windows User ID rather than login id?

1. I installed the file and selected all the options.    How can I get it to work from the Add-In Manager?   I pointed to the default location (installation path), but that didn't work.   Any ideas?


puppydogbuddyConnect With a Mentor Commented:
You shouldn't need the add-in should have been installed as an  available add-in
1.Load your test db
2.Select tools/addins/security add-in
3. afterthe security objects are installed, make the bug fixes as instructed
Gustav BrockConnect With a Mentor CIOCommented:
> view who's currently logged into the db

LdbViewer does this:;en-us;176670

> lock the db so that no one else can open up the db while some maintenance is performed.

Open the database file exclusively.


TomBock2004Author Commented:
Thanks for the info...  I appreciate the feedback.


P.S.   I'll split the points for good measures.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.