ACCESS USERS

  • Thread starter Thread starter barbiej1969
  • Start date Start date
B

barbiej1969

Is it possible to create a field that stores the identity
of the user who has entered particular data into an Access
database that has multiple users?
 
Only if you do the input through a form, or through VBA.

You can use the code in http://www.mvps.org/access/api/api0008.htm at "The
Access Web" to determine what their network name is, or if you've applied
Access Security, so that they need to log into your database, you can use
the built-in CurrentUser function. You can't, however, use those functions
as the default for a table field: you need to assign it as the default for a
text box on a form, or else you can modify the SQL associated with a query
in VBA so that it has their ID as a constant.
 
Back
Top