Auditing Programmatic Changes - Help!

[scotiwis]

We have a series of very large Access db's (using linked tables from SQL).
We need to be able to audit/track all changes made to forms/reports/VBA (and ideally queries) by our programmers.
Data auditing is fine - have programmed that into it.
But how on earth do you audit programmatic changes.
Any clues from anyone would be greatly appreciated.

Many thanks

[rpeare]

I don't think you can other than to make notes in the comments of all your code and/or keep all replaced objects (queries, reports, forms, etc) for a specific amount of time in case you need to revert to them.

[June7]

I agree: notes in code, comment out old code, copies of objects in db, and backups of the file.

[scotiwis]

Thanks guys, but not sure how notes in code etc would work. What I need is something that will output to an audit table all changes made to the databases. eg if the programmer goes in and changes the underlying VBA on a control I need the audit table to reflect their change. If a report is amended I need the audit table to reflect it. ie all program changes made need to automatically be reflected in an audit table. The idea is that the programmers can't change anything without it being tracked and audited.

[rpeare]

I think we already answered that question. It's not possible unless you create a audit log and your programmers log their changes manually. It is not something you can do automatically. Comments in VBA are noted by string starting with ' so for instance if you wanted to add a comment to a section of code that was added today you'd have something like

'this coded modified 11/6/2012 by scotwis to include negative numbers

Changes to queries, reports, forms etc can all be noted in the vba window so even if you have no code running when you open a report you can still have a vba window with comments about that report and what was changed on what day but it's strictly a manual process.