ACCESS - User Id's.

  • Thread starter Thread starter TC
  • Start date Start date
T

TC

The CurrentUser() function returns the name of the user who logged-on to
Access. However, this is only useful when you have:

(1) defined some users in your workgroup file, and

(2) added a password to the Admin user - this makes everyone have to log-on,
in future, by entering a valid username & password.

If you have *not* added a password to the Admin user, then, everyone is
automatically logged-on as Admin, & CurrentUser() will always return
"Admin" - no help!

HTH,
TC
 
Very cool !!

TC


david epsom dot com dot au said:
Or if you use
/user
on the command line of your shortcut to MSACCESS.EXE that you
use to start your application

for example

c:\msaccess.exe c:\myapp.mdb /wrkgrp c:\mywrkgrp.mda /user %username%

(automatically picking up user name from environment)

(david)
Click to expand...
 
How do I capture the user-id of the person adding or
modifing records in an ACCESS table? I would also like to
capture the date and time of the modifications.

Thank you
 
(2) added a password to the Admin user - this makes everyone

Or if you use
/user
on the command line of your shortcut to MSACCESS.EXE that you
use to start your application

for example

c:\msaccess.exe c:\myapp.mdb /wrkgrp c:\mywrkgrp.mda /user %username%

(automatically picking up user name from environment)

(david)
 
Back
Top