Garry Robinson's form "frmJetUserRoster"

Posted on 2005-04-22
Last Modified: 2011-10-03
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
Question by:TomBock2004
    LVL 22

    Expert Comment

    by:Kelvin Sparks
    Try this source
    It may do whjat you're looking for
    LVL 38

    Expert Comment

    The link below is for free security wizard that might give you more flexibility.

    Author Comment

    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?


    LVL 38

    Assisted Solution

    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
    LVL 48

    Assisted Solution

    by:Gustav Brock
    > 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.


    LVL 22

    Accepted Solution

    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

    Author Comment

    Thanks for the info...  I appreciate the feedback.


    P.S.   I'll split the points for good measures.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now