User name Stamping

[khwaja]

How could onerange for a user name stamping on a record created and saved using a form. In corporate environment, log in IDs are commonly used and I wonder if there is a facility that allows automatic saving of log in ID as soon as the record is saved in multi user environment.

Cheers

 

[nickjar2]

Hi,

Have you tried either:
environ("username&quot

or

currentUser() Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)

 

[khwaja]

Thanks a lot. I am amazed by the capabilities of Access. Appreciate your guidance. I am using Currentuser statement that returns Admin but I am sure when used it in multi user environment, it would show the name of person amending the record. I have one concern though. It is currently showing Admin for all records but in the event that someone else amends one record or adds one, would this have a global effect and replace all previous current user info? Ideally, I would like to retain the current user info for anyone previously entered or modified a record so that I have different user names for different records. As I have not made this database available to other users, I am unable to experiment. Considering the fact that it has had a global effect now, I suspect anyone else working on the form may overwrite previous current user. What do you think.

Regards

AK

 

[khwaja]

Thanks a lot. I am amazed by the capabilities of Access. Appreciate your guidance. I am using Currentuser statement that returns Admin but I am sure when used it in multi user environment, it would show the name of person amending the record. I have one concern though. It is currently showing Admin for all records but in the event that someone else amends one record or adds one, would this have a global effect and replace all previous current user info? Ideally, I would like to retain the current user info for anyone previously entered or modified a record so that I have different user names for different records. As I have not made this database available to other users, I am unable to experiment. Considering the fact that it has had a global effect now, I suspect anyone else working on the form may overwrite previous current user. What do you think?

Regards

AK

 

[nickjar2]

Hi,

CurrentUSer() will work fine in a multiusr environment. Are u using Acc 2000? I have had loads of problems with 1 database in a multiuser environment. Constantly getting corrupted and crashing. Good luck! Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)

 

[khwaja]

Thanks. I am using acess 97. Are you confirming that each individual record will not be affected when worked on by different users?

Regards

 

[nickjar2]

Oh No no no!!
It is probably better to introduce some sort of record locking to ensure that only 1 person can edit a particular record at any one time.
Using currentUser() on, for eg. when the record is updated will insert the name of the user who has changed the record. But when another user comes along and changes the record, their user name will then get inserted into the field(whatever field this may be) and therefore overwrite the previos user's name. Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)