Recording user changes on forms

[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

 

[nieurig]

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.

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