Creation of user activity logs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm looking for a way to create basic text files that record user activity within a database. Any changes to the data (additions, edits, etc) would be recorded in this text file along with the user's ID, date, and time. This file would then need to be protected from edits by anyone other than the Access program, of course

If this is not possible, then I am considering creating a new table that would contain this data instead of a text file. The only way I see this being possible, is adding a snippet of code to every field in every form in the DB that would add data to this log table when the data is changed

The second method seems awfully cumbersome and I am hoping there is an easier way to do this, perhaps with the text file as mentioned first

Any ideas, suggestions, examples, et cetra would be appreciated

- John G.
 
I realize now that this question was placed into the Security section and probably has a more appropriate section that it belongs. If any moderators can move the post, feel free. Otherwise, if anyone has any suggestions, I'd still appreciate the help

Thank you

- John
 
Back
Top