current user returns admin

[icccapital]

I would like to log in one of the databases the username of the person who is
making changes to a record in a database, but I noticed that access 2207
doesn't have user level security anymore and the currentuser method just
returns admin. Is there a way to do this?

 

[Minton M]

I would like to log in one of the databases the username of the person who is
making changes to a record in a database, but I noticed that access 2207
doesn't have user level security anymore and the currentuser method just
returns admin. Is there a way to do this?

I can think of several ways:

- Implement your own user authentication to track users - not
difficult but not very secure.
- Use SQL Server Express' user security (v. secure, easy, but only one
user per 'session').
- Snag the windows login ID if that's reliable (ie. users not sharing
IDs).

-- James

 

[icccapital]

Is there a function for getting the windows login id?

 

[George Nicholson]

http://mvps.org/access/api/api0008.htm

 

[icccapital]

Ok thanks. I had found that but wasn't sure if there was a prepackaged
function in the api I could use. Thanks