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 ?
Sounds like an interesting utility. The impact on code caused by adding or altering a column would be nice to measure. I like the idea of presenting an impact chart to my boss when he asks for a change. I would also like to determine the impact on forms and reports. What and how many forms and reports are affected.
I definitely want to know not just the impacted but the non-impacted values on the chart. Then I really know the percentage of impact.
I want to be able to drill down. Let me switch between listing and graphical view. Decide which (bar, line or pie) is the best communicator. Show me just the impact/non-impact overall and then determine the impact breakdown by reference type. Then show me listings of the references. Let me look at it from as many valuable angles as possible.
<I definitely want to know not just the impacted but the non-impacted values on the chart. Then I really know the percentage of impact.
>>This can be done, but is going to take much time.
But tell me, why you need to know the Non-Impacted values too ??
<Decide which (bar, line or pie) is the best communicator.
>>This sounds sophisticated.
Overall, your requirements are challenging. What you have in mind is a really professional tool.