Here's a .vbs file we use at my workplace for accomplishing the same function, but in this case it checks if the user has the most current version of the Access...
I would go your route using an audit table. That's what we do where I work. We store the old and new information together in the same record, what form/page the change...