Capture Password

[tbeers]

I don't know if this is possible but here is what I am trying to do. I have a multi user database in Access 2003. I am building 4 levels of security, that is to say I will have 4 groups. Actually, that's not important. What I would like to do is capture the logon password to use within the program to track who and when entries or edits are being done. Is there any method to capture the logon password or is there a better way to log activity. One of the fields in the table and the form is a "datemodifi ed" field the is enabled, but locked and updates the timestamp everytime it is entered.

-Thanks

-Tom

[Dan2kx]

there is a "currentuse r()" command which will return the name of the access user logged in, i dont know much about it and i havent tried it so you google it and im sure you will come up with something, or in access help,

[MMcCarthy]

Hi Tom

To the best of my knowledge you can't retrieve the password programmaticall y. However, you can user the Currentuser() function to retrieve the current user of the database.