We have a fairly large Access application with a SQL2000 back-end (about 120 users) which is one of our core systems - local government to manage properties, rates, and all sorts of applications (building consents, resource consents, etc.).

It's quite a configurable application, which is great in allowing us to configure it for all sorts of processes, but it's not so good at enforcing data integrity or ensuring users follow proper processes.

We have created a wide variety of audit scripts (I think we're up to about 200 now) that check all sorts of data entry, relationships, etc. Each can be scheduled to run daily/weekly/monthly, on any given day, fire emails back to the users to notify them to fix the data, and escalate the issues if they are left unresolved.

I'm sure there are plenty of tools around to do this, but we just created a simple DTS package with a couple of control tables and a series of scripts. Saves us heaps of time and helps identify repeat offenders, who might need further training, or just a damn good thrashing.