Getting the user Identification

[Aietoe]

Hi,

Using Access97, i have a database that is used by many users.
In a query, a table is updated with a field "Currentuser".

I always receive the identification «ADMIN» from whatever user is updating the table!!!!!!

Any hint would be appreciated.

Thanks

Aietoe

 

[KenReay]

Hi

CurrentUser() only returns the current user if you are using Access security and your users are logging in, otherwise it returns Admin, as you have found

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Aietoe]

Thank you very much Ken.

 

[Rick39]

You could use Environ("username&quot

 

[Aietoe]

Thanks a lot Rick39.
While i was waiting for a solution , i did try that one and it work fine.

I am always surprised how fast we get answers and fine solutions from that site...... )

Thanks again

 

[Rick39]

Glad it helped