AnsweredAssumed Answered

re: _usermod

Question asked by mark_d2x on Jun 18, 2009
Latest reply on Jun 18, 2009 by mark_d2x

Title

re: _usermod & _timemod backups

Post

Hi me again!

 

Just another one (I am sure there are going to be many more! <giggles>).  I have been asked if it is possible to permanantly record who has modified a table.

 

What i thought was to create a new table - MODIFICATION RECORD - in this I want to sequentially store who and when someone has made a record within that table - this may be best done as a seperate database (advise me please!), what I thought was to have the following: _kp_Mod record (auto enter serial number), _kf_primary key table, user mod, mod timestamp as the fields.  Then I thought about a script for the layout that copies the user mod and user timestamp from the main table on exit of that layout - is this the best way/ only way or is there an easier way to keep a long term track of who has modified a record?

 

Best wishes

 

Mark 

Outcomes