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.

Have you posted this in the MS Access forum?

Certus, you are the man I'm looking for.

Currently, my utility do searches in form modules and standard modules only. Later, I shall extend it to report modules also.

My utility is able to filter out all the table references. It can differentiate table references from non-table references, such as form references, report references, etc.

My utility does display a pie chart as part of the result.

Now could you tell me :

(1) How do you want the Impact Chart to look like ?

(2) What information do you want to be shown in the Impact Chart ?

(3) How detailed should the information be ?

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.

It will be available soon ... for download ...