Hi

Just a quick question

Is there any way that I can view which users are logged onto the database?

Thanks

Use the CurrentUser() Function

use ldbview.exe

Thanks for your quick replys

The currentuser() works but only for that user, I want to see everyone who are logged on to the Database at the time.

Thanks

Maybe you can use this (http://www.mvps.org/access/modules/mdl0055.htm) ldb viewer.

To see who's logged into the database i allways use ldbview.exe.
It shows you who is/was logged in the database. The ldb file was dropped the moment every user closes the database.

You have to locate the LDBVIEW.EXE on the internet.

Enjoy!

Have you considered just opening the LDB file as a text file (as in, use Notepad)? It's pretty simple to iterate through what's in there and get what you're after.