Who's in my database

[SueBK]

I've found the thread http://www.access-programmers.co.uk/forums/showthread.php?t=155950, with the sample database that tells you who in currently in a database. However, I'm running Access 2007, which the author said he had tested it for. I'm getting a debug message, but I don't know if that's the database programing not suited to Access 2007 or if I'm missing something that makes it run.

When I click the "connections" button, the code it highlights to debug is :

.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Me.TxtPath & "\" & Me.TxtFile

Can anyone help? Perhaps "DCrake" who supplied the database waaaay back in 2008?

 

[PaulO]

Try the attached ... it's a feature I have used before.

It's simple (maybe too simple) but effective enough perhaps for what you want to achieve ... logs each User into Logged_Users table on entry and deletes them on Exit via the Main Menu.

It's easy enough from there to build a form, query, or report to show Logged-In users at any point in time.



ps: David Crake passed away earlier in the Year

 

[jdraw]

There is code here to do what you want.
http://support.microsoft.com/kb/285822

 

[Alansidman]

And here is yet one more solution that you may wish to explore:

http://www.datawright.com.au/access_resources/access_logging_users.htm

Alan