Tracing update data

[le888]

Hi everyone,

I have a form which it is for update. My boss asks me if I can trace data when was the database was update or changing data. Where should I start and how? Should I add a columne on the table which is update? Please give me information concerning how to trace update data.

Thanks,

Le

 

[___]

Do a search here for 'Audit Trail', there are some good examples here.

HTH

 

[ghudson]

I prefer this one...
http://www.access-programmers.co.uk/forums/showthread.php?t=44231

 

[le888]

Thanks guys, I will take a look on it.

Regards,

Le