Record User id

[dbaggett]

Is there a way to have Access add a user id to a table with the time, say
when they run a certain query? List the machine id maybe. Without the user
having to key it in every time.

 

[Allen Browne]

Design an interface (form) where the user can click a button to run the
query. In the button's Click event, you actually execute 2 queries: the
original one, and an Append query that adds the logging record you want.

To get the current computer name, see the code in this link:
http://www.mvps.org/access/api/api0009.htm

Or, if you wanted to record the network user name:
http://www.mvps.org/access/api/api0008.htm

 

[PMK]

I use

=environ$("ComputerName")

which does the trick for me - just create a field in your table that you
want to store this in and then add that field to your form, set the default
value to that string and bob's your uncle

HTH

PMK