Users

[Emma]

Hi My database is password protected so that each user can log in with their
own password. How do I retrieve the username? I have a Table called Tbl Staff
which holds the users of the database under the name Staff Name. I tried
using [Tbl Staff]![Staff Name] but it doesn't grab the username.

 

[Brendan Reynolds]

Hi My database is password protected so that each user can log in with
their
own password. How do I retrieve the username? I have a Table called Tbl
Staff
which holds the users of the database under the name Staff Name. I tried
using [Tbl Staff]![Staff Name] but it doesn't grab the username.

The CurrentUser() function returns the user name of the currently logged-in
user.

 

[Douglas J. Steele]

By "password protected", do you mean that Access User-Level Security has
been applied, so that each user has to log into the application (providing a
user id and password), or are they simply providing a password, now user id?

If Access ULS has been applied, the CurrentUser() function will return their
log in ID.

The code from http://www.mvps.org/access/api/api0008.htm at "The Access Web"
will allow you to retrieve the current user's network id.

 

[Emma]

Thanks it was the CurrentUser() I was looking for. You guys are great!

By "password protected", do you mean that Access User-Level Security has
been applied, so that each user has to log into the application (providing a
user id and password), or are they simply providing a password, now user id?

If Access ULS has been applied, the CurrentUser() function will return their
log in ID.

The code from http://www.mvps.org/access/api/api0008.htm at "The Access Web"
will allow you to retrieve the current user's network id.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi My database is password protected so that each user can log in with
their
own password. How do I retrieve the username? I have a Table called Tbl
Staff
which holds the users of the database under the name Staff Name. I tried
using [Tbl Staff]![Staff Name] but it doesn't grab the username.