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 (NetworkID.zip) with Garry's form at URL