how can i creat a table to log users activigties

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • fuadmab
    New Member
    • Feb 2010
    • 6

    how can i creat a table to log users activigties

    i have a multiuser access and i would like to know what other users did during the day . Like a log file to see if a certatin user did so and the other did that
    thanks
  • MrDeej
    New Member
    • Apr 2007
    • 157

    #2
    Make a function which writes lines to a table on each event the user does. We use this inn all our forms.

    Comment

    • missinglinq
      Recognized Expert Specialist
      • Nov 2006
      • 3533

      #3
      You're talking about creating an audit trail. This is not an easy task, if you wnt it to be comprehensive, but Allen Browne has an example on his site along with a write up on what it can do and what it cannot do:

      How to create an audit log to record the history of changes to records in a Microsoft Access database - edits, inserts, and deletions.


      Welcome to Bytes!

      Linq ;0)>

      Comment

      Working...