Show Users

  • Thread starter Thread starter George Pryhuber
  • Start date Start date
G

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
 
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
 
Back
Top