Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012

    Unanswered: database change loging system

    i am curently buildinag a database on access 2007, and would like the system to log each time the records in a spacific table are changed. i have trued to do this by making a loging table, but i think for this to work, i would need it to automaticaly chand the data in one table when the data in another is changed, wich i dont think is posable. Any advice on how to do this would be usefull, thank you very much,

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    forgot who, could be Lebans, has a sectiuon on this sort of thign. do a google for MS Access audit log.

    the main issue you have is that its not automated (ie Access / JET doesn't support the idea of triggers which woudl cause the db to do soemthign on each and every change. instead it can be done programatically. that means you adding the code to each and very form.
    it also means you cannot use the data sheet view (but then persoanlly I never ever allow users to see a table in datasheet view)
    because its done via code, then there is an exposure that a deliberately malicious user could circumvent any code by updating the tables from another application.

    I wouldn't want to rely on Access / JET logging of activity. if you change the back end to something which supports triggers and you properly design the security procdures and policies then you could rely on the application in a legal context
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts