locked
How to stamp current user in a table after upadate RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1324141504 posted

     Users login to an MS Access database table called users with a password and the time logged in is also captured in the same table.

    If this user updates a record in another table called KTdata, I want that user's name stamped in this table.

    Can anyone help or refer me to a helpful tutorial.

    Regards

    James

    Wednesday, August 18, 2010 9:11 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    User188494879 posted

    You could have modified_user, modified_date columns in your tables.

    And when you are peforming an update make an insert/update to these columns also with logged in user and Todays date time values. 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 18, 2010 10:05 AM