Recording user changes on forms

  • Thread starter Thread starter Senad
  • Start date Start date
S

Senad

Hi All

I am developing a databse which will be used in a multi
user enviroment and one of the requirements is to record
user changes on the input forms.

Therefore I would be gratefully if someone could point me
in the right direction.

Thanks
 
Hi Senad,
I am developing a databse which will be used in a multi
user enviroment and one of the requirements is to record
user changes on the input forms.
Click to expand...
If you only like to save how have chanced a value a
additional table would be fine.

RecordID, UserID, DateTime

Your application have to store records to this table after
each data manipulation.

If you like to save the way of changes, probably to
additional field will help.

RecordID, UserID, DateTime, FieldName, NewValue

Your application have to save with Field would changed an
witch new value was entered.
The information into this table gave you the oppertunity
to restore all datachanges in the past.

Good luck.
Niels
 
Back
Top