Audit Log (1 Viewer)

[HJAMES]

My customer want me to keep a log of any change that is made to a record and to also record who made the change.

I have a log in screen so I know who the user is. My problem is I'm not sure how to do the audit log.

He wants to know which field was changed, the existing data and the new data.

I visualize a new table which can be appended to with possibly 6 fields.
Field 1 would have the key to the record - in this case LabNo, Field 2 would be the user id, UserId,
Field 3 would hold the field name - e.g. PhoneNo,
Field 4 would have the current data - CurrentData
Field 5 would have the new data - NewData and Field 6 Date().

Any ideas?

Helen

 

[Fuga]

If you are going to do it this way - with a "changes table" - I think it will be better to have a table for each field that can be changed, containing:

1 labno
2 userID
3 Data
4 Date()

I´m no expert on the normalization process, so take your time to think it through (and hopefully one of the experts will reply as well)



One thing I´m quite sure of, though, you don´t need two fields for the data (old data of record 2 will be the same as new data in record 1 etc)

Fuga.

 

[ghudson]

Check out Roger's Audit Trial db samples @
http://www.rogersaccesslibrary.com/index.htm

HTH

 

[HJAMES]

Thank you both for your quick response - I will take a look at the sample.

 

[HJAMES]

Thanks ghudson - it's exactly what I was looking for and it works great!

 

[sqaengineer]

Audit Trial for a Infopath Application

Hi All,

I am trying to see how to implement the Audit Trial feature for a app that uses the Forms created in Infopath and MsAccess is the Database.

Any ideas on this one, will be greatly appreciated.

Thanks much.