Unanswered: Finding out the IMPACT of changing a Table -- Utility
I have written a utility with MS Access --- this utility helps me to quickly understand the impact of changing a table structure.
When given a table name, it tries to find out how many references are there in the VBA codes. It reports all the procedures or functions which contain references. You may also select an individual procedure and then look at all the references in that procedure.
It also reports what type of statement each one is, e.g.
it might be referenced in a OpenRecordset statement OR
referenced in an aggregate function OR
referenced in RunSQL statement, etc.
It also shows a pie chart of the % of the statement types.
*** Hey guys ! I need your input ***
>> Do you think this is enough ?
>> What else can I add to this utility ?
>> What needs to be changed ?