KB Q285822

  • Thread starter Thread starter Stanley
  • Start date Start date
S

Stanley

HOW TO: Determine Who Is Logged onto a Database by Using
Microsoft Jet UserRoster in Access 2002

I am looking at the above referenced knowledge base
article, and I have a question with it.
I have a back end and when it corrupts I'd like to see who
is logged on and who is in a suspect state.
In Access 97 I used the ldb viewer program.
This is supposted to do the same thing.
The problem is I can only run this with the code in the
backend mdb, and if the backend corrupts, I cannot open it
to run this code??? Any ideas?
Thanks,
Stan
 
Have you tried setting the connection to the BE's connection string? To find it, open any module in the backend, then in the debug window type ?CurrentProject.Connection

You should get something similar to this:
Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Path\Database.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database=C:\PROGRA~1\COMMON~1\System\SYSTEM.MDW;Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False

Then, paste the code from the article into your front end (or any other db for that matter), and change the line:

Set cn = CurrentProject.Connection

to

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Path\Database.mdb"

Your connection string may be a little different based on your security (you will need the System Database option if you have secured your db), but that is the general idea (and you don't need a lot of the info contained in the string). For help with the string you can also look at www.connectionstrings.com.

HTH,
Jake

----- Stanley wrote: -----

HOW TO: Determine Who Is Logged onto a Database by Using
Microsoft Jet UserRoster in Access 2002

I am looking at the above referenced knowledge base
article, and I have a question with it.
I have a back end and when it corrupts I'd like to see who
is logged on and who is in a suspect state.
In Access 97 I used the ldb viewer program.
This is supposted to do the same thing.
The problem is I can only run this with the code in the
backend mdb, and if the backend corrupts, I cannot open it
to run this code??? Any ideas?
Thanks,
Stan
 
Back
Top