• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

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.  

Thanks,
Tom

P.S.  I posted a sample db (NetworkID.zip) with Garry's form at URL
http://tombock2004.i8.com/Test 
0
TomBock2004
Asked:
TomBock2004
  • 2
  • 2
  • 2
  • +1
3 Solutions
 
Kelvin SparksCommented:
Try this source
http://www.mvps.org/access/api/api0062.htm
It may do whjat you're looking for
0
 
puppydogbuddyCommented:
The link below is for free security wizard that might give you more flexibility.
http://www.accesswizards.com/Downloads.html
0
 
TomBock2004Author Commented:
Thanks to both of your for the info... just some follow-up questions:


kelvinsparks:
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?


puppydogbuddy:
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?


Tom

0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
puppydogbuddyCommented:
Tom,
You shouldn't need the add-in manager....it 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
0
 
Gustav BrockCIOCommented:
> view who's currently logged into the db

LdbViewer does this:

  http://support.microsoft.com/default.aspx?scid=kb;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.

/gustav

0
 
Kelvin SparksCommented:
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
0
 
TomBock2004Author Commented:
Thanks for the info...  I appreciate the feedback.

Tom

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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now