Changelog in Access?

[Remphan]

How to track changes to the database Access, keep a log of changes. Or compare recordset with an array in Excel?

The "Microsoft Access 2010 PROGRAMMER'S REFERENCE" there is a common example of using these macros to track changes in tables.

Or create a table with logs and global function to record logs, and forms the events to use this feature?

What is the best and simple decision?

 

[Grumm]

Best way is to make a table and save the history in there. Here is a pretty complete example : http://www.techrepublic.com/article/a-simple-solution-for-tracking-changes-to-access-data/

All you need is 1 table and 1 function so that is pretty simple.