Show Users

[George Pryhuber]

I have tried the Microsoft code in the following article:
(HOW TO: Check Who Logged into Database with Jet
UserRoster in Access 2000).
However, I have a password protected database and don't
know how to work around the password using the code
provided with the above Microsoft article. The needed
password gives an error msg.

Thanks for your help!

Sincerely,

George Pryhuber

 

[Guest]

Hi George
I tried the ShowUserRoster code too from this website http://support.microsoft.com/?id=198755#2. It worked fine in the Northwind database but did not work with my workgroup-protected database. I entered the correct path to the location of the database on the server in the two necessary places

cn.Provider = "Microsoft.Jet.OLEDB.4.0
cn.Open "Data Source=\\franas\f\SBCT-3\Fielding\USF_Database\USF_Req_Tables.mdb

cn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;"
& "Data Source=\\franas\f\SBCT-3\Fielding\USF_Database\USF_Req_Tables.mdb

However, when I type in the ShowUserRosterMultipleUsers into the Immediate Window, nothing comes up. (Not even an error
Does this code work across the network with the BE on the server and the FE on the local machine(s)? I need to know who is accessing the BE tables, so when I need to make a development table change, I can ask them to close the app.

Can anyone assist George and me on this issue? This is a great 2K utility and would love to have it work for us
Thank you very much
Mar