BGBM Model Integrity Checker (Name_Integrity.adp, Ref_Integrity.adp and PT_Integrity.adp) Access Project ---------------------------- How to use the integrity checker: - run the scripts 'CreateFunctionsForIntegrityChecker.sql' and 'CreateProceduresForIntegrityChecker.sql' - if you don't have two tables named 'integ*' in your database use the script 'CreateTablesForIntegrityChecker.sql' to create them - create your own ini file named 'BMIntegrity.ini' by editing it - open Name_Integrity.adp, Ref_Integrity.adp or PT_Integrity.adp, and run the Checker - If you don't want to use all integrity rules close the opening form and comment out the rules in Checker main() you do not want to perform - the Message table will now contain the problems which have been detected How to add a rule to the rule wishlist - add the rule (and your name) to the TO DO LIST section within the Checker module - consider to implement this rule yourself ;-) How to implement a rule - Follow the syntax of the rules already implemented and add you rule as a new procedure at the end of the Checker module - Each rule should have a unique id. Make sure that the messages created by your rule include their id - Remove the rule from the TO DO LIST - Add the rule to the AVAILABLE RULE SECTION - Add the procedure call to main()