Automated Audit Queries
With all large database systems, it is not possible to enforce all the business rules through referential integrity and data entry validation. I've found it's useful to have a set of Queries that check the data integrity. This gives confidence to everyone in the database.
This code automates the running of those queries and for those queries that return records (potential problems), it emails the details to a designated person.
Programming Notes

There's flags for Weekly and Monthly processing, but the process could be run at any interval.


Demo of Audit Queries [arriving soon]
Forms and Code [arriving soon]

Copyright 2006 Databases By Design. Read Terms of Use and Privacy Policy.
Designed and deployed by Interspeed Web Solutions Limited.