Login capture

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

Dear All,

i have a MS Access database where users login using their indvidual user
accounts, is there a way to capture the userid and date/time stamp so if the
users adds entries to the database it will capture the login id and the
date/time stamp in a table?

I would apreciate if someone can assist?

many thanks
jay
 
Doug,

thanks for the response, the login i want capture is the database login not
the network, i am not familiar with the programming languages, so if you
could help in a simplest term.

thanks
 
Sorry, for the database login, there's a built-in function CurrentUser()

If you go into the definition for your table, look at the properties for the
fields in question. Set their DefaultValue properties to CurrentUser() and
Now(). (Note that this would not have been possible if you were looking for
the Windows ID, which is what my first response assumed)
 
thank you very much, very helpful

Douglas J. Steele said:
Sorry, for the database login, there's a built-in function CurrentUser()

If you go into the definition for your table, look at the properties for the
fields in question. Set their DefaultValue properties to CurrentUser() and
Now(). (Note that this would not have been possible if you were looking for
the Windows ID, which is what my first response assumed)
 
Back
Top