Track changes made to a db 1

[CHTHOMAS]

Hello,<br><br>could any one suggest or tell me how to track down changes made to the table of a db. I am using Access8.0. Any help or suggestions will be highly appreciated.<br><br>Regards and Thanks<br><br>Charley

 

[JimHorton]

Assuming you're talking to changes to the <i>Table</i> itself...<br>Use MsysObjects, the DateModified field.&nbsp;&nbsp;Read that field at your chosen event/interval, by Object Name, and you can store it in another table, then compare it against the last event/interval in which you checked that objects date .<br><br>If you meant changes to the <i>Records</i> in the table, then you need to know <b>all</b> avenues of data entry/updates, and have a 'date changed' field in the table, and write the current date to that field on an AfterUpdate event, or after any code which changes the data.<br>--Jim

 

[elizabeth]

You can put in a default value of Date() in a DateAdded field, and create a second field DateUpdated just for changes. This makes it a bit simpler to concentrate on just changes. Also if you want to track deletes, you can copy those deleted records into another table at the time they are deleted.