See who's logged in to any Db from my computer

[ColinEssex]

Hi All,

I was thinking it would be nice to have a little Db on my PC that I can select any database thats sat on a server and see the following-

1) Names of who's logged in

2) Their PC number

There is an LDB viewer application that we use to pick up the PC number and it works fine, no probs. It doesn't tell you who the user is (ie their network name)

I did a search here and found this thread....

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=40986&highlight=whos+logged+on

There is a comment by GHudson (dated Jan 2003) that he has yet to find anything that will return the UserName remotely. I can do it by running code within the selected Db, but not by doing anything from a DB on my PC.

Has anyone cracked this yet for use with Access 97?

Col

 

[IMO]

Col,

I don't know if this is what you're looking for. Written by Mark Davis.

IMO

 

[Mile-O]

With Access '97,


I have a database backend that contains a number of tables: one table for errors, one for users, one for databases, one for users, one for user logs past and one for user log present. etc. There's a junction table, too, connecting databases and users.

Each database I make links to these tables.

If an error occurs then I use an error handler subroutine to write the error to the database detailing which database the error occurred, the time, the error and its description, the user, the form/module it occurred on, and the subroutine/function it occurred in.

If a user logs in to a database then, by DAO, I write their login, the database name, and their time of entry to the userlog current.
When they log out I append their details, with Time Out to the user log previous and then delete it from the user log present.

On this database with all these tables waiting to be linked to I have a frontend round it too that lets me administrate all my database from it. I can add new users' details into the users table (including their email address). I then have other forms which, in a listbox on the left, have the names of all the databases I have listed and a listbox on the right, that, when the database listbox is clicked, shows a list of all people within that database, or, if on another form, all errors that have occurred.

These lists let me drill further into them in that I can click on a user and I can reset their access to the database (if they manage to escape it without logging out in the way prescribed for them, they can't get back in.) Those who try to get in but don't have access have as many details about them as I can get logged and they are also listed as 'Unauthorised.'

By using the OpenCurrentDatabase command I can use the listbox also to open the database I want immediately without having to go looking for it in a folder full of shortcuts, etc.

The other thing this database allows me to do is show a list of databases, a list of those who have access to it, and a list of all other people who don't. From here I can select someone in either listbox and switch their access back and forth. An email is sent to them informing them of their access and how to get set up.


Given you any ideas?

 

[IMO]

Helps if I post them!!

IMO

 

[IMO]

2nd Zip

IMO

 

[IMO]

3rd Zip

IMO

 

[ColinEssex]

Mile-O

What can I say?? Thank you, and I'm not surprised you have a very comprehensive admin type database.

I like the idea of having the "login" tables sat in a Db on your PC and posting to them when users login. That seems a very good move. How you do some of the other stuff I'm afraid is beyond my skills I think I'll print off your reply and study it over the next year or two!!!

I appreciate your comprehensive response - thanks again.

Thanks too to IMO for the attachments, I'll have a look at those today.

Col

 

[IMO]

I knew I'd seen what you are looking for, and I've found it again.

IMO

 

[ColinEssex]

IMO - mixed success sadly.

The first 3 downloads came up with the "path missing" error and I couldn't seem to shake it and it didn't do anything.

The last download (AppUser97) seemed the best, but wouldn't run on A97, it said that there was code in the form it couldn't understand, I couldn't even get into the form design.
I ran it in A2000 and it managed to pick up when I was in another A2000 Db but errored when it tried to identify an A97 Db.

not sure whats happening really. - perhaps I should go home and lie in a darkened room.

Col

 

[IMO]

Oh well, it was worth a try

IMO

 

[ColinEssex]

I appreciate your help IMO - I'll post again with a result, should I get one. I reckon Mile-O's seems favourite at the moment although as I said, it'll take me ages to understand it all

Col

 

[ghudson]

The last download (AppUser97) seemed the best, but wouldn't run on A97, it said that there was code in the form it couldn't understand, I couldn't even get into the form design.

There are two functions in the appuser.zip sample that Access 97 does not know what to do with since they were created in newer versions of Access. I tried to do the same thing a couple of weeks ago at this posting Disconnect all clients then Backup but Access 97 does not like the Private Enum auLDBErrors declarations and the Split function.

HTH