UpdateDate field in MSysObjects system table

[richardn]

I would like to know when records or data in a table was changed.
I tried to use the DateUpdate field of MSysObjects system table to catch any change in contents of table. When I change records (delete, update, append) and closing the table without SAVE, the DateUpdate field did not change.(update)
When saving after record changes, the field did update itself.
However it can not be helpfully for me as it will not indicate that record changed in table.
Looking forward to your answer.

 

[WayneRyan]

Richard,

Those tables are for Access to use, you should not touch
them. You should try something like this:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=44231&highlight=audit

Wayne