Which user is currently logged access 2007

W

Willy Wonka

I'm deperately trying to find a way to list all those users currently logged
in to my shared database in Access 2007. I see options for 2003 but nothing
seems to work for 2007. Help! (and please be gentle, I'm not a hardcore
programmer...)
 
K

Klatuu

Workgroup Security was dropped in 2007, so how it was done previously will
not work. If there is another direct way, I am not aware of it.

One way to do it is to have a user table with a record for each user. When
the user logs in, update that user's record with the current date/time and
when he logs out, set the field back to Null.
 
B

Bernd Gilles

Klatuu said:
Workgroup Security was dropped in 2007, so how it was done previously will
not work. If there is another direct way, I am not aware of it.

One way to do it is to have a user table with a record for each user. When
the user logs in, update that user's record with the current date/time and
when he logs out, set the field back to Null.

You can still use workgroup security with access 2007!

The only thing you have to keep in mind: use access 2003 file format
instead of 2007 file format when creating a new database.

With that, workgroup security should work as in the pre-2007 times ;-)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top