Solved action / change log

[TipsyWolf]

hey guys,
do u have any simple ideas \ solutions that record every changes* made by anyone ? no admin \ users log in system required.

like it does it automatically

ActionLOG table
1. [tablename][filedname][recordID] changed from X to Y
or something like it

upd:
*im looking to track changes for 1 or 2 tables max.

 

[theDBguy]

You can take a look at this old article.

Audit Trail using Data Macros

There are different ways to do audit trails in Access. Up until Access 2010, these had to be implemented on the Form level. But Access 2010 has Data macros which operate on the Table level, so they…

scottgem.wordpress.com

 

[arnelgp]

allen browne also has Audit trail, using VBA.
Allen Browne - Creating an Audit Log