How to see ALL users, not only logged users?

[selvsagt]

Hi,

I have a db with 3 users operating with forms, and 15 users operating with DAP's.

I dont use access security because the users using dap's gets a load of login forms, on for each dap. (i.e I have 8 daps in one html file). In stead I have an easy html code that restricts the users who can view the file by their network username. The "formusers" logs on with a startupform (these logins are stored).

The structure works great except for the fact that it is difficult to determine which users that has a DAP open. The "formusers" sits beside me so kicking them out is easy.

Is there a way to see ALL users who are either logged on to the base, or viewing or registering data on a dap?

It's quite anoying to make the walk through the office and ask, "do you have the base open?" Especially when they all sit in different stories, buildings and so on.

I've tried to find a way to read the contents of the ldb file, but haven't figured it out yet. I reckon that it contains info on everything thats currently going on, but I lack the knowledge to seeing whats going on.

How can I make a module (preferably a form) to see all users? I have found many forum treads about users logged in to the base, but not a single post on seeing users accessing the base with dap's.

I am a rookie to VB, and my knowledge is limited to pasting other peoples codes and altering it so it fits my base (I keep the credit lines to the writer of course), so please dont send my to an article posted by microsoft or anything, because I never manage to make those work.

Anyone have an idea on how to do this?
A form that shows preferably the network username of everyone accessing data from my db?

Need help!

 

[Bodisathva]

while you can find applications to read the .ldb file, you can also open it with WordPad (not Notepad).

 

[ghudson]

You can open the .ldb [record locking file] with Notepad.exe. I have my computer set to open any .ldb with the Notepad.exe program when I double click the file from Windows Explorer.

The record locking file lists the users workgroup name that they logged into the db with and also their computer name. The .ldb file will add new users as long as the database is left open by one user. The .ldb does not always drop a users info when they close the db. The .ldb file will be deleted when the last user closes the db. The .ldb file will not be deleted if a users has not correctly closed the .mdb [like if they turn off their PC or Ctrl+Alt+Del the program.]

 

[selvsagt]

When I open the file in notepad it looks encrypted.
Like this:

呗こ3†††††††††††††摡業n†††††††††††††呗こ3†††††††††††††摁業n†††††††††††††呗こ3†††††††††††††摁業n†††††††††††††呗こ3†††††††††††††摁業n†††††††††††††呗こ3†††††††††††††摁業n†††††††††††††呗こ3†††††††††††††摁業n†††††††††††††呗こ3†††††††††††††摁業n†††††††††††††呗こ3†††††††††††††摁業n†††††††††††††

Wordpad however worked, and looked like this:
WTS03 Admin WTS03 Admin WTS03 Admin WTS03 Admin WTS03 Admin WTS03 Admin WTS03 Admin WTS03 Admin

The problem now is... Who the heck is WTS03 admin, and how many users had the db open?
3 users (that I know of) had the file open, and they dont sit on WTS03, and their loginname is not Admin (neither is mine).

I guess the problem is that we all sit in Citrix network, and the file only reads the amount of connections the servers have.
any suggestions to how I can solve this problem, without converting to sql?

 

[ghudson]

Citrix is preventing you from seeing what you need. Since everybody is sharing the db which is located on one server you are seeing the name of the Citrix box and Admin is the default workgroup name. All db's are secured and Admin is the out of the box default. You could have a seperate directory created and place a copy of the front end for each specific user [each front end is linked to the one back end that stores the shared tables] but that would be alot of work if you have more than 10 users. You can build your own login/logout routine where you capture the users login and logout date/time and also their network name. There are plenty of other threads disccusing that so the answer is within this forum is you choose to go that route. Good luck!

 

[selvsagt]

Thank you.
I have to upgrade to Sql soon anyway. My administrator will probably demand it.

Thank you for your help, I really appreciate it.

K.

 

[Bodisathva]

You can open the .ldb [record locking file] with Notepad.exe.

I can open .ldb files with Notepad, but I cannot read them with notepad. I assume that the encryption comes through in the case of secured networks, but I have only been able to read the .ldbs using WordPad. (of couse, I haven't tried it on an unsecure network or PC either)

 

[ghudson]

I have to admit that sometimes the data looks garbled but now I know that it must be the secured encryption on our network but most of the time it is readable with Notepad. I would just reopen the file a few times but I thought that it was Access 2003 that was more secured when we upgraded I noticed the difference.

 

[selvsagt]

A little comment, and back to the orginal question... How to see who's viewing my db.

I have a log for each time a user logs on through the logonform. I use a onload command that records this (code obtain in forum here).
It captures the network username, and the workstation. The username they use in Access is not recorded.

The logfile looks like this.
PJN is the networkusername of my boss, and PCPJN is the computername. He sits on a regular computer. The other user, brk, kfo and oja sits on Citrix clients.

But the logfile captures the network names and not the "admin" name that came out in the .ldb file.

(stasjon=workstation, åpnet=opened, lukket=closed benyttet=used)

Database åpnet  av pjn benyttet stasjon PCPJN :   : 07.08.2006 13:39:38
Database lukket av oja benyttet stasjon WTS03 :---: 07.08.2006 14:05:58
Database åpnet  av kfo benyttet stasjon WTS04 :   : 07.08.2006 14:24:05
Database lukket av pjn benyttet stasjon PCPJN :---: 07.08.2006 15:58:22
Database lukket av kfo benyttet stasjon WTS04 :---: 07.08.2006 16:01:25
Database åpnet  av oja benyttet stasjon WTS03 :   : 08.08.2006 13:14:35
Database lukket av oja benyttet stasjon WTS03 :---: 08.08.2006 14:21:14
Database åpnet  av brk benyttet stasjon WTS02 :   : 08.08.2006 16:39:28
Database lukket av brk benyttet stasjon WTS02 :---: 08.08.2006 16:44:19

In other words, access is able to capture the networkusername when a user logs on directly to the db, but only the "admin" username when a user ses the db through a dap.

Obviously the user information is there to see. And the error lies in that i dont have the proper code. I found this code:

Public Function GetUserID()
GetUserID = Dlookup ("[UserID]", "TblUsers", [Username]=" & Environ("Username")"")
End Function

How can I translate this to a logfile for DAPS?

If i'm pushing my luck here, feel free to tell me.
I use this forum because you guys are the best.

K.

 

[workmad3]

if you have a logon form in your db that you created yourself, and a list of users, then you can always have a 'logged on' flag next to your user that is set when the user signs in and is unset when the user exits the app or clicks a log off button. Not the most effective way, but it should get the results you want

 

[selvsagt]

That will only work in the "form" interface.
The DAP's only checkes in the HTML code if the user is authenticated to open the index file. I use the "Authenticate User", and plot the networkusernames directly into the html code (no lookups in the db). Probably not the wisest solution...

It must be some way to return the network username...