Interrogating the History information
Hi - is there a way to interrogate the database history? The history for my Db only goes back 48 hours but I may need to go back further when our auditors come in. If someone could let me know that would be great
Thanks
3 replies
-
Hi Inspector 99
I don't rely on this history file at all as it store too much info that I don't want and i have no contrrol over how long it stores etc.
What I do - Is I use various audit files (ie tables -) that mirror any key tables that I want to keep audit info on. Then every time a user writes/update a record the the system updates (copies) certain key fields plus the user/ and record creation date/time etc. That way I can keep the audit table for as long as I want but in fact I also have a script in global scripts area that checks everytime a user logs on a deletes any records over x years for each audit table. I also set all these audit tables to invisible unless an unlock code it set in the system table.
Works for me....
-
Thanks for that Mel - I have implemented that this morning!
-
Great - glad your sorted :-)
Content aside
- 3 yrs agoLast active
- 3Replies
- 205Views